How Do You 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. Enter Microsoft Excel and open a worksheet. Select the range of cells (or even the nonadjacent cells) that you want to name. Locate the name box at the top-left of the formula bar, just above the row and column headings. Click in the box and type the name you want for the cell range. Press Enter to accept the name. Use the name in formulas you create.
