Copy Formula From Cell Above

Using the Copy Formula From Cell Above Shortcut

Windows keyboard shortcut

 
Mac keyboard shortcut

This Excel shortcut copies the formula in the cell above to the current cell and leaves it in edit mode. If you are copying a formula, no cell references will change.
Other useful Entering Data keyboard shortcuts