
254
=A1+A2
=A1+A2
=A1+A2
=A1+A2
11
33
22
44
4 Release the mouse button.
●
Excel moves the formula to the
new location.
MOVE A FORMULA
1 Select the cell that contains the
formula you want to move.
2 Position over any outside
border of the cell.
changes to .
3 Click and drag the cell to the new
location.
●
Excel displays an outline of the cell.
●
Excel displays the address of the
new location.
Move or Copy a Formula
You can restructure or reorganize a worksheet by
moving an existing formula to a different part of
the worksheet. When you move a formula, Excel
preserves the formula’s range references.
Excel also enables you to make a copy of a formula, which ...