View Single Post
  #1   Report Post  
marisa
 
Posts: n/a
Default Excel should let me create an automated list of the name box

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
"InsertNameDefine" 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/comm...lic.excel.misc