Things You'll Need:
- Excel Book
- Microsoft Excel
-
Step 1
Enter Microsoft Excel and open a worksheet.
-
Step 2
Select the range of cells (or even the nonadjacent cells) that you want to name.
-
Step 3
Locate the name box at the top-left of the formula bar, just above the row and column headings.
-
Step 4
Click in the box and type the name you want for the cell range.
-
Step 5
Press Enter to accept the name.
-
Step 6
Use the name in formulas you create.










