Excel like a finance pro.
← The libraryPractice · 2 questions →
Formulas shortcut
Paste a defined name into a formula
F3 on Windows, F3 on Mac.
Rarely usedDifficulty 1100 · Proficient
When to use it
While editing a formula, opens a list of defined names to paste one in.
The shape of it
- Windows
F3
- Mac
F3
Worked examples
Paste a name
Type =SUM( then F3, pick Sales → =SUM(Sales
No typing of the name.
List all names
F3, Paste List, on an empty sheet → A list of every name and what it refers to
Documentation.
No names
F3 with no names → Nothing happens
Define some with Ctrl + F3.
Worth knowing
- Autocomplete also suggests names as you type.
- Paste List documents a model's names.
- Table names are not in the list; type them.
Where it goes wrong
- Only defined names appear, not Table columns.
- Does nothing outside edit mode when there are no names.
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.