Excel: Obtaining a List of the Defined Names in a Document

ID: Q50261


The information in this article applies to:


SUMMARY

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:

  1. Select the cell you want to be the upper-left corner of the list of names.


  2. 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.


MORE INFORMATION

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


Keywords          : 
Version           : 
Platform          : 
Issue type        : 

Last Reviewed: March 15, 1999