Excel like a finance pro.
← The libraryPractice · 2 questions →
Formulas shortcut
Open Name Manager
Ctrl + F3 on Windows, ⌘ + F3 on Mac.
CommonDifficulty 1050 · Capable
When to use it
Opens Name Manager, where defined names are created, edited, and deleted.
The shape of it
- Windows
Ctrl + F3
- Mac
⌘ + F3
Worked examples
Name an input
Ctrl + F3, New, name TaxRate, refers to =$B$1 → A named cell usable as =A2*TaxRate
Readable formulas.
Find broken names
Ctrl + F3, filter to Names with Errors → Broken names listed
Cleanup after deleting sheets.
Repoint a name
Ctrl + F3, edit a name's Refers To → Repoint a range
Grow a range.
Worth knowing
- Type a name in the Name Box for a quick definition.
- Names can hold formulas and constants, not just ranges.
- F3 pastes a name into a formula.
Where it goes wrong
- Hidden names from add-ins clutter the list.
- Deleting a name breaks formulas using it with #NAME?.
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.