Relative References When Using Copy and Cut

If you Copy and Paste a formula, its references will be transferred using relative referencing. Thus, if you Copy the formula = A1 +1 from cell A2 and Paste it in cell A10, the formula in cell A10 will be =A9+1. If you Copy the formula from cell A2 and Paste it in cell C2, the formula in cell C2 will be =C1 +1. (This is probably not the formula you want.) [Pg.27]

On the other hand, if you Cut the formula in cell A2 and Paste it anywhere in the worksheet, it will still be the formula =A1 +1. [Pg.27]

Thus the difference (with respect to cell references) between Copy and Paste and Cut and Paste is that Cut adjusts relative references so that they stiU refer to the original cells, while Copy does not adjust relative references, with the result that they refer to different cells. [Pg.27]

The best way to copy a formula to a different row and column without altering relative references is to Copy it from the formula bar, click the Enter box to complete the Copy operation, then Paste in the destination cell. [Pg.27]

Big Chemical Encyclopedia

Chemical substances, components, reactions, process design ...