Range Names List

If you use range names then it is a good idea to include a list of all the range names in a file for documentation purposes.

There is a shortcut that does all the work for you.

Select the cell where you want to enter the list.

Press F3 and then click the Paste List button.


The list has two columns. The range name and it’s reference.

The list is not dynamic. If you add, delete or change the names you will need to do the paste again.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.