Document your workbooks by printing a list of range names. Share them with others who use and modify your workbook files.
- 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.