How to Define Cell Ranges in Excel

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