Copying or Moving Formulas and Their Computed Values
Here are techniques for copying and moving cells related to a formula:
To copy the computed value in a formula cell but not the formula, select the cell,
m
choose Edit > Copy, select the cell you want to hold the value, and then choose Edit >
Paste Values.
To copy or move a formula cell or a cell that a formula refers to, follow the instructions
m
in “Copying and Moving Cells” on page 88.
If the table is large and you want to move the formula to a cell that’s out of view, select
the cell, choose Edit > “Mark for Move,” select the other cell, and then choose Edit >
Move. For example, if the formula =A1 is in cell D1 and you want to move the same
formula to cell X1, select D1, choose Edit > “Mark for Move,” select X1, and then choose
Edit > Move. The formula =A1 appears in cell X1.
If you copy or move a formula cell, change cell references, as “Distinguishing Absolute
and Relative Cell References” on page 129 describes, if needed.
If you move a cell that a formula refers to, the cell reference in the formula is
automatically updated. For example, if a reference to A1 appears in a formula and you
move A1 to D95, the cell reference in the formula becomes D95.