Datasheet

120
PART II
■
GETTING THE DATA IN
double-click the Fill handle, the formula or cell entry is filled all the way
down the column until there’s no entry in the cell to the left.
Formulas copied with AutoFill adjust themselves so that every relative
reference refers to the correct cell relative to the formula cell (the rela-
tive references do the adjusting).
Figure 4.14. Click and drag or double-click the Fill handle to copy the
formula down the column.
Linking worksheets and workbooks
You can write formulas that reference cells in other worksheets or work-
books; those formulas link the worksheets or workbooks.
Formulas that link worksheets
It’s a great convenience to be able to write a formula on one worksheet
that calculates cells on a different worksheet. For example, I often tran-
scribe client lists of household goods and their replacement values for
insurance claims, and the very long list is on one worksheet while the very
short summary list is on a second worksheet (which eliminates scrolling to
see the totals).
Fill handle
Bright Idea
If you want a formula to calculate one changing cell with one unchanging
cell, such as the cells in a Price column and an unchanging TaxRate cell, write
the formula quickly with relative references and then change the TaxRate cell
reference to absolute. Better yet, name the TaxRate cell.
09_763217 ch04.qxp 1/18/06 11:23 PM Page 120