# Copy Exact Formula

When you copy a formula, **Excel** automatically adjusts the cell references for each new cell the formula is copied to.

For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1.

When you copy this formula to cell B3 (select cell A3, press CTRL + c, select cell B3, press CTRL + v), the formula will automatically reference the values in Column B.

If you don't want this but instead want to **copy** the **exact formula** (without changing the cell references), execute the following easy steps.

1. Click in the formula bar and select the formula.

2. Press CTRL + c, and press Enter.

3. Select cell B3 and click in the formula bar again.

4. Press CTRL + v, and press Enter.

Result:

Both cell A3 and cell B3 contain the exact same formula now.

Did you find this information helpful? Show your appreciation, share this page.

Tweet |

Go to Top: Copy Exact Formula | Go to Next Example: 3D-reference