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

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Topics

Key functions

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. Read more.

Just wanted to give a HUGE thank you for all of your content. I was NOT proficient at Excel, even though my resume clearly says differently ;), until I found this website. Now, I've become the "Excel Guy" at my company and I owe 90%-ish to ExcelJet. I have yet to find another website that gives clear, concise, and in-depth explanations like you do. KEEP UP THE GREAT WORK! -James

Copy value from cell above

Download 200+ Excel Shortcuts

Excel video training