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.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.