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

ID: Q50261

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:

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.

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 :