Printing a List of Named Ranges

Anyone who has created a large workbook knows that it is very easy to create a large list of named ranges. Managing those ranges, particularly if you inherit the workbook from someone else, is a much harder task. Part of the problem is that you may lose track of all your ranges and what they refer to.

Having a list of the names in your workbook could be helpful. To get a list, follow these steps:

1. Select the cell where you want the list to start. Since a name list can occupy a good deal of space, you may want to select a cell in a blank worksheet.
2. Choose the Name option from the Insert menu. Excel displays a submenu.
3. Choose Paste from the submenu. (This option is not available if there are no named ranges in your workbook.) Excel displays the Paste Name dialog box. (Click here to see a related figure.)
4. Click on Paste List. The two-column list of names and their ranges are inserted.