Excel should let me create an automated list of the name box

[Guest]

When the name box is used to link cells from other worksheets, or to link
matrices to a single name, for lots of data, one can get lost as to what name
links to what cell/group of cells, especially if it is a "hand-me-down"
spreadsheet. Is there a way to make an automated list that shows you the
name and what cell(s) it links to instead of going through
"Insert>Name>Define" and copy the name, paste in Word, then go back and copy
the "Refers to" field and re-paste in Word, n-times?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...8-bfdf7c61989e&dg=microsoft.public.excel.misc

 

[George Nicholson]

You mean something like:
- Activate an empty sheet
- Insert>Name>Paste>PasteList

Should give you a two-column list: NamedRanges and RefersTo

HTH,

 

[Gord Dibben]

Select a cell in an empty column.

Insert>Name>Paste>Paste List.

This function has been around for many versions of Excel.


Gord Dibben Excel MVP