- Select any cell in the range and press [Ctrl]+[Shift]+* to select the contiguous range. (There's a great keyboard shortcut you might not know!)
- Choose Name from the Insert menu and then choose Create. If you're using Excel 2007, click the Formulas tab and choose Create From Selection in the Defined Names group.
- Excel will display the Create Names dialog box; it does a good job of finding the label text. Usually, you won't have to change the settings, but you can.
- Click OK.
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.