Excel like a finance pro.
← The libraryPractice · 2 questions →
Editing shortcut
Copy
Ctrl + C on Windows, ⌘ + C on Mac.
Daily driverDifficulty 750 · Novice
When to use it
Copies the selection to the clipboard, showing a moving border around what was copied.
The shape of it
- Windows
Ctrl + C
- Mac
⌘ + C
Worked examples
Copy a block
Select A1:B10, Ctrl + C, click D1, Ctrl + V → A copy appears at D1
The basic move.
Copy a formula
Copy a formula cell, select a range, Ctrl + V → The formula is pasted into every cell with adjusted references
Relative references shift.
Copy for values
Ctrl + C, then Ctrl + Alt + V, V → Values only
Paste Special after a copy.
Worth knowing
- Esc clears the moving border.
- You can paste the same copy several times until you press Esc or edit a cell.
- Copying a whole column copies a million cells; copy the data range instead.
Where it goes wrong
- Copying merged cells and pasting into a different layout fails.
- Copies from filtered ranges include hidden rows unless Alt + ; is used first.
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.