Excel like a finance pro.
← The libraryPractice · 2 questions →
Workbook shortcut
Open the Macros dialog
Alt + F8 on Windows, Fn + Option + F8 on Mac.
CommonDifficulty 1050 · Capable
When to use it
Opens the Macros dialog to run, edit, or delete a macro.
The shape of it
- Windows
Alt + F8
- Mac
Fn + Option + F8
Worked examples
Run a macro
Press Alt + F8, pick a macro, Run → The macro runs
Run without a button.
Assign a key
Alt + F8, Options → Assign a shortcut key
Faster next time.
Edit
Alt + F8, Edit → Opens the code
Inspect.
Worth knowing
- Ctrl + letter shortcuts assigned here override Excel's own; use Ctrl + Shift + letter.
- Macros in the Personal workbook appear in every file.
- Save first; macros cannot be undone.
Where it goes wrong
- Macros with arguments do not appear in the list.
- Disabled macros show nothing until the file is trusted.
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.