Datasheet

118
PART II
■
GETTING THE DATA IN
cell because of the relative references. The advantages and disadvantages
of using relative references become clear when you copy formula cells to
a new location.
Figure 4.12. This formula subtracts one date (in cell D2) from another date (in cell D3)
to how the number of days between; there’s no quick automated tool for subtraction.
Moving and copying formulas
You use all the same techniques for moving and copying formula cells as
for nonformula cells, but sometimes with different results.
When you move a formula cell, the formula moves intact and the cell
references stay the same regardless of the reference types of the input
cells. But when you copy a formula cell, bad things can happen if you’re
not prepared for them (see Figure 4.13).
Copy a formula cell
When you copy formulas, the reference type comes into play. Absolute
references do not adjust when you copy a formula; they always calculate
the same input cells.
Hack
You can quickly show all the formulas in a worksheet if you press Ctrl+` (the grave
accent on the same key as the tilde (~). Press Ctrl+` again to hide the formulas.
09_763217 ch04.qxp 1/18/06 11:23 PM Page 118