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 demonstrate this shortcut.
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.
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.