Printing a List of Named Ranges

Summary: If your workbook has quite a few defined name ranges, then you may find it helpful to print out a list of those ranges for reference. This is easy to do using the steps in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

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:

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.
Choose the Name option from the Insert menu. Excel displays a submenu.
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.)
Click on Paste List. The two-column list of names and their ranges are inserted.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2944) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Don't Go in Debt for Christmas! Tired of trying to keep up with the Joneses for Christmas? Want to enjoy the season rather than dread the aftermath? Learn how you can avoid the financial traps that spring up every Christmas.

Check out Top Fifteen Tips for Financing Christmas today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Printing a List of Named Ranges