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

 Last reviewed: November 29, 1994
Article 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:

  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.

KBCategory: kbusage
KBSubcategory:

Additional words: 2.2 2.20 3.0 3.00 4.0 4.00 macrosheets

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.