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.
Search JabSto ::




Custom Search