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

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.

Just a quick note to let you know the hard work you've clearly put into your website is soooo valuable to folks like myself. This has very quickly become my favorite excel site! So clean, so devoid of excel-snobs arguing over best practices like so many forums, and so robust in the amount of topics you guys cover. Thank you!

Copy value from cell above

Related videos

Download 200+ Excel Shortcuts

Excel video training