Microsoft Office Tutorials and References

In Depth Information

**Copying Versus Cutting a Formula**

Figure 9.14.

Figure 9.14.
Using cut and paste on a formula forces the formula to continue

Using cut and paste on a formula forces the formula to continue

to point to the original cells.

to point to the original cells.

When you cut a formula, the formula continues to point to the original pre-

cedents, no matter where you paste it.

A similar rule applies to the references mentioned in a formula. For example,

the formula in cell C7 points to A7 and B7. As long as you copy cell A7 and/

or cell B7, you can paste them anywhere without changing the formula in C7.

Figure 9.15
shows the result of copying A7:B7 for 20 rows: Nothing changes in

the formula.