Microsoft Office Tutorials and References

In Depth Information

**Add a Range Name to a Formula**

Add a Range Name

to a Formula

You can make your formulas easier to build, more

accurate, and easier to read by using range names as

operands instead of cell and range addresses. For

example, the formula =SUM(B2:B10) is difficult to

decipher on its own, particularly if you cannot see

the range B2:B10 to examine its values. However, if

you use the formula =SUM(Expenses), instead, it

becomes immediately obvious what the formula is

meant to do.

See Chapter 4 to learn how to define names for

ranges in Excel.

Add a Range Name to a Formula

1
Click in the cell in which you

want to build the formula, type

, and then type any operands
=

and operators you need before

adding the range name.

2
Click the
Formulas
tab.

3
Click
Use in Formula
.

A
Excel displays a list of the range

names in the current workbook.

4
Click the range name you want

to use.