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

form.antibot { display: none !important; } You must have JavaScript enabled to use this form.

Thank you for your clear explanation on the sumifs function. It was exactly what I needed to simplify a massive spreadsheet where I need to summarize a range of amounts from over 70 sheets in a workbook. The previous person would manually update the formulas each year but now the "sumifs between dates" formula will automate this. Huge Thanks!! -Sarah

Copy value from cell above

Download 200+ Excel Shortcuts

Excel video training