Exceljet

Quick, clean, and to the point

Copy value from cell above

Windows shortcut 
CtrlShift"
Mac shortcut 
⌃⇧"

This shortcut copies the value in the cell above to the selected cell and leaves the cell in edit mode. If the cell above is a formula, only the value is copied.

222 Excel Shortcuts for Windows and Mac

Related videos

Tip: Shortcuts to enter data in Excel
Shortcuts to enter data in Excel
Did you know you can use shortcuts to control the direction Excel moves when you press Enter? In this video, learn a boatload of shortcuts for entering data in Excel.