Excel like a finance pro.
← The libraryPractice · 2 questions →
Editing shortcut
Copy the value from the cell above
Ctrl + Shift + " on Windows, Ctrl + Shift + " on Mac.
OccasionalDifficulty 1150 · Proficient
When to use it
Copies the value (not the formula) from the cell directly above into the active cell.
The shape of it
- Windows
Ctrl + Shift + "
- Mac
Ctrl + Shift + "
Worked examples
Copy a value
Cell above shows 1,250 from a formula, press Ctrl + Shift + " → This cell gets 1250 as a number
Freeze one value.
Repeat a label
Repeat a label down a column → Same text each row
Without retyping.
Dates
Ctrl + Shift + " in a date column → The same date
Dates copy as their value.
Worth knowing
- Ctrl + ' copies the formula instead.
- It enters edit mode; Enter to confirm.
- Ctrl + D copies the formula relatively.
Where it goes wrong
- Only from the cell above.
- Formatting is not copied.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.