Move or copy a formula

When you move a formula, the cell references within the formula do not change. When you copy a formula, the cell references may change based on the type of reference used.

  1. Select the cell that contains the formula.
  2. Verify that the cell references used in the formula will produce the result you want. Switch to the type of reference you need. To move a formula, use an absolute reference (absolute cell reference: In a formula, the exact address of a cell, regardless of the position of the cell that contains the formula. An absolute cell reference takes the form $A$1.).

ShowHow?

  1. Select the cell that contains the formula.
  2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) Formula bar, select the reference you want to change.
  3. Press F4 to toggle through the combinations. The "Changes To" column reflects how a reference type updates if a formula containing the reference is copied two cells down and two cells to the right.

Formula being copied

Formula being copied
  1. On the Edit menu, click Copy.
  2. Select the cell you want to copy it to.
  3. To copy the formula and any formatting, on the Edit menu, click Paste.
  4. To copy the formula only, on the Edit menu, click Paste Special, and then click Formulas.

ShowTips

 
 
Applies to:
Excel 2003