When you copy a formula from one cell to another, Excel will, by default, readjust the formula cell references to reflect the change. However, if you want the formulas to stay the same, this is how we do it:

1. Click on the cell containing the formula you want to copy.

2. Press [F2].

3. Click and drag to select the entire formula.

4. Click the Copy button in the Standard toolbar.

5. Press [Enter].

6. Select the cell into which you want to paste the formula.

7. Click the Paste button in the Standard toolbar.

When you copy an Excel formula in this manner, the formula copies as text and will not adjust its cell reference. You can also copy part of a formula this way. For example, you may want to include the formula as part of an If statement in another part of the worksheet.