Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← All tips & shortcuts

Undo and redo

CtrlZEditing & references

Step backward through your changes — and forward again if you went too far.

Difficulty

Beginner

Practice file

1What it does

Ctrl + Z undoes your last action, and pressing it repeatedly walks back through the history one step at a time; Ctrl + Y redoes what you just undid. The one thing to know: a macro (or in older versions, saving) can clear the undo stack — so save a copy before running anything you can't reverse, because Ctrl + Z won't bring it back.

2The shortcut

CtrlZ

1Press Ctrl + Z to undo the last change — again to keep stepping back.
2Press Ctrl + Y to redo a step you undid.
3Before running a macro, save a copy — it can wipe the undo history.

3Before → after

Press the shortcut to play it on a sample sheet.

or press the keys for real

Before — a bad edit sits in the cell

	A — Field	B — Cash
1	Bank balance	9,999

Someone fat-fingered 9,999 into the cell. Ctrl + Z walks it back — press it repeatedly to keep stepping.

4When you use it

Back out of a mistaken edit or paste instantly.
Step back through several changes to a known-good state.
Redo a change you undid one step too far.

Want these moves already done for you? Wauvel's free tools download as branded, formula-driven Excel models — Tables, named ranges, and all.

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.