Listing Range Names in Excel

Excel has Paste List option to list the range names in the file. Here’s a macro that does it in one click.

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.ListNames

The 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.