Microsoft KB Archive/41623

How to Print All Defined Names in Excel PSS ID Number: Q41623 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.x 3.00 | 2.20 2.21 3.00

WINDOWS | OS/2

Summary:

To print out all of the names defined on a sheet, do the following:


 * 1) Open a new sheet in Excel.
 * 2) Choose the Paste Name function from the Formula menu.
 * 3) When the dialog box comes up, choose the Paste List button. This will paste a two-column list of all of the names on the sheet and their current values, starting at the active cell on the current sheet.
 * 4) Choose the Print function from the File menu.

Additional reference words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00 3.0

Copyright Microsoft Corporation 1993.