How to Paste Formulas Without Changing References

Copy a formula in Excel and the references move with it. Paste =A1+B1 one row down and it becomes =A2+B2. That relative behavior is usually helpful, but when you want an exact copy of the formula it gets in the way. Here is how to move a formula without Excel rewriting its references.

Why references shift in the first place

Excel treats most references as relative, meaning they describe a direction and distance rather than a fixed address. When you paste, Excel keeps that relative offset and recalculates the addresses for the new location. To stop the shift you either lock the references, strip the formula of its meaning during the move, or use a tool that pastes exactly.

Lock references with the dollar sign

Adding dollar signs makes a reference absolute so it never moves when copied.

1. Click into the formula and select a reference such as A1.
2. Press F4 to turn it into $A$1, which locks both row and column.
3. Repeat for every reference you want to keep fixed.
4. Copy and paste as usual; the locked references stay put while unlocked ones still shift.

Move a single formula as text

For a one-off move where you want the formula unchanged, edit it as text.

1. Press F2 to edit the cell, then select the whole formula and copy it with Ctrl+C.
2. Press Esc to leave the cell without moving it.
3. Click the destination cell, press F2, and paste with Ctrl+V, then Enter.
4. Because you copied the formula text rather than the cell, the references arrive exactly as they were. This only works one cell at a time.

Paste an exact copy with ModelMint

ModelMint Paste Exact copies formulas, formats, and column widths and pastes them precisely as they were, with references that do not shift. It works on a whole block at once, so you can lift an entire schedule to a new location without rewriting a single dollar sign or editing formulas one by one. It is the fast way to duplicate a section verbatim.