Software

Document Excel range names

Document your workbooks by printing a list of range names. Share them with others who use and modify your workbook files.

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.

About Susan Harkins

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.

Editor's Picks

Free Newsletters, In your Inbox