Microsoft KB Archive/50261

From BetaArchive Wiki

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:

  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.


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 :

Last Reviewed: March 15, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.