How to Define Cell Ranges in Excel

How to Define Cell Ranges in Excel. In Excel 2000, you can define names for cell ranges to make it easier to create and understand your formulas. For example, if the cells from J20 to J33 are all sources of income, you could name this cell range "IncomeSources" and then use that name in formulas.

Step

Enter Microsoft Excel and open a worksheet.

Step

Select the range of cells (or even the nonadjacent cells) that you want to name.

Step

Locate the name box at the top-left of the formula bar, just above the row and column headings.

Step

Click in the box and type the name you want for the cell range.

Step

Press Enter to accept the name.

Step

Use the name in formulas you create.