Microsoft KB Archive/50261

{|
 * width="100%"|

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

-

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 :

Technology :