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




Custom Search