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.
Search JabSto ::




Custom Search