Microsoft Office Tutorials and References

In Depth Information

**ALWAYS POINT TO CELL B10**

ALWAYS POINT TO

CELL B10

Challenge:
You want to create a formula that always points to cell B10. Normally,

if you have a formula that points to B10 or even $B$10, the formula changes if

you cut and paste B10 or if you insert or delete rows above row 10.

In Figure 37, a formula in D1 checks to see if a value is in cell B10. In Figure

38, even after items are deleted from rows 6, 8, and 9, the formula still reports

an item in B10, even though cell B10 is empty. This is because the formula has

changed to point to B7 in Figure 38.

Part

I

Figure 37.
h

is formula points to B10

Figure 38.
h

e reference moves to B7 if you delete three rows above B10.