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.

Related videos

The videos below show how this shortcut can be used.
In this video, we'll look at how to several ways calculate the number of days between dates. To get started, let's first first set up some dates, so we have a visual representation to refer to.
This video shows how to stop Excel from changing cell references when you want an exact copy of a formula in a different cell.
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.