- Select the cells you want to identify as a range. The Name Box in the top-left corner of the sheet will list the anchor cell (B2) for the current selection.
- Click the Name Box, enter a name for the range (in this example, North), and press Enter. That's all there is to it!
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.