Exceljet

Quick, clean, and to the point

Copy formula from cell above

Windows shortcut 
Ctrl'
Mac shortcut 
'

This shortcut copies the formula in the cell above to the active (current) current cell and leaves the cell in edit mode. This is a convenient way to make an exact copy of a formula - no cell references are changed.

A nice feature of this shortcut is that is leaves the cell in "edit mode" after the copy, so you can immediately edit. This can be handy when you want to copy a value from above and adjust the result manually. For example, if you need to enter a set of invoice numbers that are similar, but not necessarily sequential.

Related videos

The videos below demonstrate this shortcut.
In this video we'll look at several ways to calculate the number of days between dates.
Sometimes you want to reference a worksheet dynamically in a formula so that it can be changed on the fly. In this video, we'll look at how to create a dynamic reference to a worksheet in a formula.
This video shows you how to stop Excel from changing cell references when you want an exact copy of a formula in a different cell.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.