Microsoft Office Tutorials and References

In Depth Information

**Copying Versus Cutting a Formula**

Figure 9.13.

Figure 9.13.
When cell C7 is copied to cell G3, the formula still adds the two

When cell C7 is copied to cell G3, the formula still adds the two

numbers to the left of the formula.

numbers to the left of the formula.

However, if you cut cell C7 and paste it to a new location, the formula con-

tinues to point to cells A7+B7, as shown in
Figure 9.14
.
Whereas cutting and

copying are relatively similar in applications such as Word, they are very

different in Excel. It is important to understand the effect of cutting a for-

mula in Excel in contrast to copying the formula.