- 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.