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

Change Formatting Based On Your Data! Conditional formatting provides a way for you to adjust the appearance of your data based on the data itself. Discover how to put this amazingly powerful feature to work for you, today. This comprehensive volume is available in two editions.

Check out Excel Conditional Formatting today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Printing a List of Named Ranges