Moving a formula

When you move a formula or the data it refers to, your spreadsheet makes any necessary changes so that the formula still refers to the same data. More power with formulas describes all the basic parts of a formula and the different types of formulas, and Controlling how a formula refers to data describes how to work with formula references when you move a formula.

  1. Select the cell or range that contains the formula(s) you want to move.

  2. In the action bar, click Cut.

  3. Select the cell or range where you want to paste the formula(s).

  4. In the action bar, click Paste.

Notes



See also
More power with @functions
When and how formulas recalculate
Fixing common errors in formulas
Editing a formula
Entering a range address in a formula
Entering a range name in a formula
Copying a formula