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.

Paste_List

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.


Related Posts

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.

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