List of all ranges defined for a sheet

Huntb2000 · 08/09/19

Hi Folks,

We have been using a lot of cross sheet links and need to clean things up.

Is there a way to see all the named ranges used to access data in a sheet? In other words, show all the ranges and thus the sheets, that are using data from the current sheet?

Thanks!

Andrée Starå · 08/09/19

Hi,

Unfortunately, it's not possible at the moment to see a list of the ranges, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Huntb2000 · 08/09/19

Thanks Andree, Once again you have the answers. Appreciate all you do for the community.

Andrée Starå · 08/09/19

Thanks so much for the kind words!

I'm always happy to help!

Have a fantastic weekend!

Paul Newcome · 08/12/19

I would love to be able to quickly and easily get a comprehensive list of what is linked where. Until this becomes a feature, I have begun manually tracking my references on each of the source sheets.

It is a little bit of extra work, but it helps me keep everything straight. Since I am listing each reference on the source sheet, I am able to see the list whenever I link to the sheet again which helps with consistent naming conventions and helps avoid having more links than needed.

Andrée Starå · 08/13/19

Yes, that would be amazing!

Would make it so much easier when I'm working on different client solutions that aren't always structured the same.

List of all ranges defined for a sheet

Comments

Help Article Resources

Categories