Using the Copy Value From Cell Above Shortcut
Windows keyboard shortcut
Mac keyboard shortcut
This Excel shortcut copies the value 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