Datasheet

129
CHAPTER 4
■
WORKING DATA MAGIC WITH CALCULATIONS
(as many cells as you like, including cells that don’t contain formulas),
and choose Insert

Name

Apply. Click every name you want to apply
and then click OK (see Figure 4.25).
You can even name cells after you write the formulas and apply those
names to the formulas that have cell references.
Figure 4.25. Apply names to replace references in formulas.
Named ranges and apply names
When you create names in a table using the table headings as
range names, and then AutoFill or otherwise copy a formula that
references the cells in those named ranges and then apply names to
the formulas, what you get is a column of formulas that all look the
same.
For example, a Total column has formulas that multiply a Price
column by a Quantity column, and the Price and Quantity columns
are named ranges. The formulas in the Total column all read
=Price*Quantity.
Each formula is using the cells in the named range that are in its
own row, so the formulas are correct, even if it’s unnerving that
they all look the same.
09_763217 ch04.qxp 1/18/06 11:23 PM Page 129