How to Define Cell Ranges in Excel

By eHow Computers Editor

Rate: (11 Ratings)

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.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

Step1
Enter Microsoft Excel and open a worksheet.
Step2
Select the range of cells (or even the nonadjacent cells) that you want to name.
Step3
Locate the name box at the top-left of the formula bar, just above the row and column headings.
Step4
Click in the box and type the name you want for the cell range.
Step5
Press Enter to accept the name.
Step6
Use the name in formulas you create.

Tips & Warnings

  • Excell will not accept a cell-range name that includes spaces in the title.

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article:  How to Define Cell Ranges in Excel

eHow Computers Editor

eHow Computers Editor

Category: Computers

Articles: See my other articles

Related Ads