Microsoft Office Tutorials and References
In Depth Information
Simplifying a Formula with Ranges
Did You Know?
You can delete a name range. Click the Formulas tab, click the Name
Manager button, select the names you want to delete, click Delete or
press Delete, click OK to confirm, and then click Close.
What happens when you change a label reference? If you change the
name of a reference label, Excel automatically makes the change to
every formula in which the name is used.
You can label names that are relative. When you use a label name in a
formula or function, Excel sees it as a relative reference. You can copy
the formula to other cells, or use AutoFill to copy it and the reference
changes.
Simplifying a Formula with Ranges
You can simplify formulas by using ranges and range names. For example, if 12 cells on
your worksheet contain monthly budget amounts, and you want to multiply each amount
by 10%, you can insert one range address in a formula instead of inserting 12 different
cell addresses, or you can insert a range name. Using a range name in a formula helps
to identify what the formula does; the formula =TotalOrder*0.10, for example, is more
meaningful than =SUM(F6:F19)*0.10.
Use a Range in a Formula
Put your cursor where you would like the formula. Type an equal sign (=) fol-
lowed by the start of a formula, such as =SUM( .
Click the first cell of the range, and then drag to select the last cell in the range.
Excel enters the range address for you.
Search JabSto ::




Custom Search