Excel like a finance pro.
Find and replace across the whole workbook
CtrlHEditing & referencesEveryone knows the shortcut. Almost nobody uses the three options that make it safe.
Difficulty
1What it does
Ctrl + H is one of the first things anyone learns and one of the easiest ways to quietly wreck a file. Three settings behind the **Options** button change everything: **Match entire cell contents**, so replacing "Sales" doesn't also hit "Sales — East"; **Look in: Formulas**, which searches the formulas rather than the displayed results; and **Within: Workbook**, which extends it past the current sheet. Use Find All first — it lists every hit so you can see what you're about to change before you change it.
2The shortcut
- 1
Ctrl + H, then click **Options** to reveal the settings that matter. - 2Tick **Match entire cell contents** unless you genuinely want partial matches.
- 3Press **Find All** and read the list. Only then press Replace All.
3Before → after
Press the shortcut to play it on a sample sheet.
Replacing “Sales” with “Revenue”
| A — Account | |
|---|---|
| 1 | Sales |
| 2 | Sales — East |
| 3 | Sales — West |
| 4 | Presales |
Four accounts, one of which merely contains the word. Try it both ways.
4When you use it
- Rename an account consistently across every sheet.
- Repoint formulas from one tab name to another.
- Strip a stray character out of an imported column.
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.