Copy Formulas in Excel Without Changing References

To copy a formula without letting Excel adjust its cell references, lock the references with dollar signs before copying. For example, change =A2*B2 to =$A$2*$B$2 if the destination must keep pointing to A2 and B2. If you need an exact duplicate of one formula’s text instead, copy it from the formula bar and paste it into the destination formula bar.

Excel normally changes relative references when you copy or fill a formula. That behavior is useful when extending calculations down a table, but it can cause unexpected results when you want the same cells referenced every time. The steps below cover both goals: keeping references fixed as you copy and duplicating a formula exactly.

What You’ll Need

Excel for Microsoft 365 on Windows, or a recent Excel version. The main methods also work in Excel for Mac; notes explain keyboard differences.
The source formula cell and the intended destination cell or range.
If you plan to change several existing formulas, make a copy of the workbook first. This gives you a safe way to recover if references are locked incorrectly.

Step-by-Step

Decide what “without changes” means for your formula. If you want each copied formula to use the same fixed input cells, lock those references with dollar signs. If you want the formula text to remain identical, including its existing relative references, use the formula-bar method in Step 5. These are different outcomes: a formula can look identical while pointing to different cells after a normal copy.
Check how Excel would normally adjust the formula. Suppose A2 contains 3, B2 contains 5, and C2 contains the formula =A2*B2. Its result is 15. If you copy C2 to C3, Excel changes the formula to =A3*B3, because both references are relative. That is expected behavior, not a copying error. Before changing anything, identify which references should move and which should stay put.
Lock references that must not move. Select the formula cell and click in the formula bar. Add dollar signs to the column and row of every reference that must remain fixed. With values 3 in A2 and 5 in B2, the formula =$A$2*$B$2 in C2 returns 15. Copying it to C3 leaves the references as $A$2 and $B$2, so it still returns 15. Press Enter to commit the edited formula.
Use F4 to add dollar signs quickly. While editing a formula, click or select a cell reference such as A2, then press F4. Excel cycles through the reference styles: A2, $A$2, A$2, $A2, and back to A2. Choose the style that matches what should stay fixed. On a laptop, you may need Fn+F4. In Excel for Mac, select the reference and use Command+T; depending on the keyboard, Fn+F4 may also cycle the reference. In Excel for the web, browser shortcuts can interfere, so adding the dollar signs directly in the formula bar is a reliable alternative.
Copy the locked formula to the destination. Select the formula cell and press Ctrl+C on Windows, then select the destination cell or range and press Ctrl+V. On Mac, use Command+C and Command+V. You can also use the fill handle: select the formula cell and drag the small square at the lower-right corner of the selection across the cells to fill. Because the references are absolute, they stay fixed. If you use a mixed reference such as A$2, only the row is fixed; the column can still change as the formula moves sideways.
Copy one formula exactly when you need the same formula text. Select the source cell, click in the formula bar, and highlight the complete formula, starting with the equals sign. Copy it. Select the destination cell, click in its formula bar, paste, and press Enter. For example, with A2 containing 3 and B2 containing 5, copying the formula =A2*B2 from the formula bar into C3 keeps the text exactly as =A2*B2, and C3 returns the product of the values in A2 and B2: 15. A normal cell-to-cell copy would instead adjust the references to A3 and B3. Repeat this formula-bar procedure for each formula that needs an exact reference pattern.
Check the result and the formula itself. Select the destination cell and look at the formula bar. Confirm that the references are the kind you intended, not just that the displayed number looks plausible. If you copied a locked formula, verify that the dollar signs remain. If you pasted formula text, verify that it begins with an equals sign and that Excel calculated it rather than displaying it as text.

For ordinary formulas copied through a whole table, you may not need to lock every reference. A mixed reference can keep only a row or column fixed. For example, when copying a calculation across columns while always using row 1 for a rate, a reference such as B$1 fixes the row but allows the column to adjust. Choose absolute, relative, or mixed references based on how the formula should behave in each destination.

Common Mistakes

Locking every reference by default. Absolute references prevent movement in both directions. If a formula is meant to use A2 in the first row, A3 in the next, and A4 after that, changing the reference to $A$2 will make every copied formula use A2. Keep a reference relative when it should follow the formula.
Using a normal copy when you need identical text. Ctrl+C and Ctrl+V between worksheet cells normally adjust relative references. To preserve the exact reference addresses in a single formula, copy the formula text from the formula bar instead.
Locking the wrong part of a reference. A$2 fixes row 2 but lets the column change. $A2 fixes column A but lets the row change. $A$2 fixes both. A missing or misplaced dollar sign can produce errors that appear only after filling across or down.
Checking only the displayed result. Two different formulas can return the same number for the current data. Inspect the destination formula in the formula bar, especially before filling a large range or relying on a fixed input cell.
Overwriting cells that contain useful data. Pasting into a selected range replaces its contents. Check the destination selection before pasting; if necessary, use Undo immediately with Ctrl+Z on Windows or Command+Z on Mac.

Tips

Plan the reference pattern before filling. For each cell address in the formula, decide whether the row, column, both, or neither should move. Then use the appropriate reference style rather than trying to repair a whole block afterward.
Test in one nearby cell first. Copy or fill the formula once, then inspect the result and formula bar. If it behaves correctly, continue to the full destination range. This catches an incorrect reference pattern before it affects many cells.
Use the fill handle for a continuous range. After fixing references, dragging the fill handle is often quicker than copying and pasting repeatedly. Double-clicking the fill handle can fill down alongside neighboring data, but check where the adjacent data ends so formulas do not extend too far.
Keep a clear source formula. When a calculation depends on a fixed rate, tax value, or other input, consider placing that input in a clearly labeled cell and using an absolute reference to it. This makes the formula easier to audit than repeating a constant in many formulas.
Distinguish formula copying from value copying. If you want only the current answer and not a working formula, use Paste Special to paste values. On Windows, copy the cell, open Home > Paste > Paste Special, and choose Values. The result will no longer update when its inputs change. On Mac, use Home > Paste > Paste Special and choose Values; wording can vary slightly by Excel build.
Use the formula bar carefully for exact duplicates. Select only the formula text when copying. If you copy the cell itself, Excel applies its normal reference adjustment rules. When the formula bar is crowded, widen it or use the expand control so it is easier to see the entire formula before selecting it.

Troubleshooting

The copied formula points to the wrong row or column. Select the destination cell and inspect its formula bar. If a reference should stay fixed, edit the source formula to add the correct dollar signs, then copy it again. If only the row or only the column should be fixed, use a mixed reference rather than locking both.
The formula shows as text instead of calculating. Check whether the cell is formatted as Text or whether the formula begins with an apostrophe. Change the cell format to General using Home > Number Format, then re-enter the formula: select the cell, press F2, and press Enter. Changing the format alone may not convert an existing text entry until you re-enter it.
The result is an error after copying. Compare the original and copied formulas. A reference may now point to a blank cell, an unintended value, or a location that causes a division-by-zero or other error. Correct the reference style in the source and copy again. If the formula uses a named range, confirm that the name is still defined in Formulas > Name Manager.
F4 does not change the reference. Make sure you are editing the formula and that the insertion point is on, or the reference is selected as, a cell address. On a laptop try Fn+F4. If a keyboard shortcut is unavailable or intercepted, type the dollar signs directly in the formula bar.
Excel changes the formula even though you meant to copy it exactly. Use the formula-bar copy method, not a normal cell copy. If the destination formula still differs, check that you highlighted the entire source formula and pasted it into the destination formula bar before pressing Enter.

Frequently Asked Questions

Does copying a formula normally change its references?
Yes. Excel adjusts relative references based on how far the formula moves. Absolute references, marked with dollar signs, do not move when copied.

How do I copy a formula without changing any cell references?
For a formula that should keep referring to the same cells, make those references absolute with dollar signs, such as $A$2. To duplicate one formula’s exact text, copy and paste the formula through the formula bar.

What is the difference between $A$2, A$2, and $A2?
$A$2 locks both the column and row. A$2 locks only the row, while $A2 locks only the column. These mixed references are useful when filling formulas across or down.

Can I copy a formula without its formatting?
Yes. Copy the source cell, select the destination, and choose Home > Paste > Formulas. This pastes formulas without the source cell’s formatting, but relative references can still adjust. Lock references first if they must remain fixed.

Will the F4 shortcut work in Excel for the web or on Mac?
F4 works in many Windows Excel formula-editing situations, although laptop function keys may require Fn. Mac uses Command+T in many builds to cycle reference types. Excel for the web and browser settings can affect shortcuts, so editing the dollar signs directly is a dependable fallback.

Can I make a copied formula return the same number permanently?
Use Paste Special > Values to replace a formula with its current result. That result will not recalculate when the original inputs change, so keep a workbook copy if you may need the formula later.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.