Name Manager Question

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
3,161
Afternoon,
For some reason some of my drop downs stopped working.
I am now cleaning up the named manager list & these are now starting to work correctly.
In the page that opens up is there a way to click on a NAME as excel tell you on what sheet it is connected with.

Name i say name this is the page that is shown after you select Formulas / Name Manager on the tool bar.

Thanks
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,573
THe Name Manager window does show which page the named range is located on in the 'Refers to' column.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,459
Messages
5,414,647
Members
403,540
Latest member
mmorejon1215

This Week's Hot Topics

Top