Tip 233 – Easily Copy Data from the Cell Above Using a Shortcut

When you need an exact copy of the data from the cell above, in Excel, you can use a shortcut key. Press Control + ‘ to make a duplicate of the contents of the cell above the current cell. Dates, values and formulas are copied exactly so, using this shortcut, formulas won’t update relative to the target cell as they do when you copy the cell’s contents using Copy and Paste or Control + D.