Copying a formula

You can copy formulas to use them in different cells of the same sheet. When you copy a formula, you can make the formula refer to the original data or different data. When you copy formulas, your spreadsheet adjusts any relative and mixed references in the copied formulas. Your spreadsheet does not adjust absolute references.

Controlling how a formula refers to data describes how to work with formula references when you a copy formula. More power with formulas describes all the basic parts of a formula and the different types of formulas.

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

  2. (Optional) Edit the formula, if needed, to create relative, absolute, and mixed references to cell addresses.

  3. In the action bar, click Copy.

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

  5. In the action bar, click Paste.



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
Moving a formula