Wauvel

Excel like a finance pro.

← The library

Editing shortcut

Cut

Ctrl + X on Windows, ⌘ + X on Mac.

Daily driverDifficulty 750 · Novice
Practice · 2 questions →

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.