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
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.
