Datasheet

135
CHAPTER 4
■
WORKING DATA MAGIC WITH CALCULATIONS
Figure 4.29. Circling invalid data in a data-validation range
If data validation was not set up before the invalid data was entered,
you can set up validation after the fact and then run the Circle Invalid
Data button to find the bad data.
Just the facts
■
Use AutoCalculate for instant, on-the-fly calculations and AutoSum
to write fast, simple formulas.
■
Relative cell references change when you copy formula cells.
■
Absolute cell references never change, even when you move or copy
formula cells.
■
Change reference types by clicking in the reference and pressing F4
to cycle through the four types.
■
Move and copy formula cells with the same methods you use to
move and copy nonformula cells, but watch out for reference types.
■
Use cell names for easy-to-understand formulas and stable cell
references.
Circle Invalid Data
Invalid data
Invalid data
09_763217 ch04.qxp 1/18/06 11:23 PM Page 135