- Jan 22, 2026
Listing Range Names in Excel
- Neale Blackwood
- Macros, Range Names
- 0 comments
Excel has Paste List option to list the range names in the file. Here’s a macro that does it in one click.
Sign up to hear about free Excel training.
I won't share your email with anyone.
1 min read
To paste a list of range names and their references press the F3 function key and click the Paste List button.
If you record a macro to do it, you find the command is a single line of code.
Selection.ListNamesThe list doesn’t auto update, so you need to re-paste it after range name changes.
You can link the recorded macro to an icon on the Quick Access Toolbar to re-paste the list in one click.