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 |
#2
|
|||
|
|||
You mean something like:
- Activate an empty sheet - InsertNamePastePasteList Should give you a two-column list: NamedRanges and RefersTo HTH, -- George Nicholson Remove 'Junk' from return address. "marisa" wrote in message ... 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 |
#3
|
|||
|
|||
Select a cell in an empty column.
InsertNamePastePaste List. This function has been around for many versions of Excel. Gord Dibben Excel MVP On Tue, 5 Jul 2005 13:00:02 -0700, marisa wrote: 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 |
Reply |
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) |