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.

Related videos

Tip: 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.
I love your articles. They're the cleanest, most efficient place to get Excel knowledge. - Sebastian
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course