# Move or copy a formula

It's important to be aware of what can happen to cell references (cell reference: The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.), whether they are absolute (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.) or relative (relative reference: In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to. If you copy the formula, the reference automatically adjusts. A relative reference takes the form A1.), when you move a formula by cutting and pasting it, or copy a formula by copying and pasting it.

- When you move a formula, the cell references within the formula do not change no matter what type of cell reference that you use.
- When you copy a formula, the cell references may change based on the type of cell reference that you use.

## Move a formula

- Select the cell that contains the formula that you want to move.
- On the
**Home**tab, in the**Clipboard**group, click**Cut**.

You can also move formulas by dragging the border of the selected cell to the upper-left cell of the paste area. Any existing data is replaced.

- Do one of the following:
- To paste the formula and any formatting, on the
**Home**tab, in the**Clipboard**group, click**Paste**. - To paste the formula only, on the
**Home**tab, in the**Clipboard**group, click**Paste**, click**Paste Special**, and then click**Formulas**.

## Copy a formula

- Select the cell that contains the formula that you want to copy.
- On the
**Home**tab, in the**Clipboard**group, click**Copy**. - Do one of the following:
- To paste the formula and any formatting, on the
**Home**tab, in the**Clipboard**group, click**Paste**. - To paste the formula only, on the
**Home**tab, in the**Clipboard**group, click**Paste**, click**Paste Special**, and then click**Formulas**.

** Note ** You can paste only the formula results. On the **Home** tab, in the **Clipboard** group, click **Paste**, click **Paste Special**, and then click **Values**.

- Verify that the cell references in the formula produce the result that you want. If necessary, switch the type of reference by doing the following:

- Select the cell that contains the formula.
- 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.) , select the reference that you want to change.
- Press F4 to switch between the combinations.

The following table summarizes how a reference type updates if a formula that contains the reference is copied two cells down and two cells to the right.

For a formula being copied: |
If the reference is: |
It changes to: |
---|---|---|

$A$1 (absolute column and absolute row) | $A$1 | |

A$1 (relative column and absolute row) | C$1 | |

$A1 (absolute column and relative row) | $A3 | |

A1 (relative column and relative row) | C3 |

** Note ** You can also copy formulas into adjacent cells by using the fill handle (fill handle: The small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a black cross.) . After verifying that the cell references in the formula produce the result that you want in step 4, select the cell that contains the copied formula, and then drag the fill handle over the range that you want to fill.