Quickly copy above cell value to current cell in Excel

Updated: 12/30/2021 by Computer Hope
excel cell tip

In Microsoft Excel, pressing Ctrl+Shift+" (quote) copies the above cell's contents to the current cell. For example, if you were working in cell A2 and cell A1 contained the text "Computer," pressing Ctrl+Shift+" inserts the word "Computer" in cell A2.

Tip

The keyboard shortcut Ctrl+D can fill a range (more than one) of cells in a column with the contents of the topmost cell, including its formatting or a formula.