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.
Excel will generate a list of range names and their references. At this point, simply print the list and share it. Excel won’t automatically update the list, so you must remember to generate a new list when you add or delete ranges.