When you modify a workbook, a reference list of range names might be useful. A list is especially helpful if you didn't create the workbook; it's difficult to keep up with all the ranges you and others have created. To print a list of range names, do the following:
- Select an out of the way spot in your workbook; you're going to create the list in the workbook before printing it.
- Select Name from the Insert menu and then choose Paste from the resulting submenu. (If there are no ranges in your workbook, this command isn't available.)
- When Excel displays the Paste Name dialog box, click Paste List.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.