Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can Excel create a list of tabs on a worksheet? | Excel Discussion (Misc queries) | |||
How do I create a list of sequential numbers using Excel or Acces. | Excel Discussion (Misc queries) | |||
Excel List range, filter arrows disappeared | Excel Discussion (Misc queries) | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
How to I create a pdf file from Word or Excel files | Excel Discussion (Misc queries) |