Excel like a finance pro.
← The libraryPractice · 2 questions →
Editing shortcut
Cut
Ctrl + X on Windows, ⌘ + X on Mac.
Daily driverDifficulty 750 · Novice
When to use it
Cuts the selection so the next paste moves it, keeping references pointed at the moved cells.
The shape of it
- Windows
Ctrl + X
- Mac
⌘ + X
Worked examples
Move a range
Select A1:A10, Ctrl + X, click C1, Ctrl + V → The cells move to C1:C10
Formulas referencing A1:A10 now reference C1:C10.
References follow
Cut a cell referenced elsewhere, paste it → Every formula follows it
Unlike copy, which leaves the original.
Cancel a cut
Ctrl + X, then Esc → The cut is cancelled
Nothing moves until you paste.
Worth knowing
- Cut and paste is the safe way to reorganize a model; formulas follow the moved cells.
- Cut only allows one paste.
- Dragging a selection border does the same thing.
Where it goes wrong
- Cutting over a range that formulas point to breaks them with #REF! if the target is inside the cut area.
- Paste Special is not available after a cut.
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.