Microsoft KB Archive/50261
Excel: Obtaining a List of the Defined Names in a Document
The information in this article applies to:
- Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0
In Microsoft Excel versions 2.2, 3.0 and 4.0, you can paste a list of defined names and their references into a worksheet by using the Paste Name command as follows:
- Select the cell you want to be the upper-left corner of the list of names.
- From the Formula menu, select Paste Name and choose the Paste List button.
Excel pastes the names from that worksheet in a list with the references for each name in the column directly to the right.
NOTE: The same method can be used to list the names defined in a macro sheet.
In Excel versions 1.00, 1.03, 1.04, 1.06, and 1.50, the only way to create a list of the names defined on the worksheet (or macro sheet) is to save the worksheet as SYLK and open the resulting document using a word-processing program that can read text files (such as Microsoft Word). Use the search feature of your word processor to locate a particular name in this file.
Additional query words: macrosheets
Issue type :
Last Reviewed: March 15, 1999