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:

  1. Select an out of the way spot in your workbook; you’re going to create the list in the workbook before printing it.
  2. 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.)
  3. 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.