Copy Formulas in Excel Exactly: Keep References Fixed

To copy a formula in Excel, select its cell, press Ctrl+C, select the destination, and press Ctrl+V. Excel normally adjusts relative cell references to suit the new location. If you need the formula to keep referring to the same cells, make those references absolute with dollar signs before copying, or copy the formula text through the formula bar. The right method depends on whether you want the same formula pattern, the same formula text, or the same referenced cells.

This guide covers Excel for Microsoft 365 on Windows. Copying a formula does not usually copy only its visible result: it copies the calculation and may also copy formatting, depending on the paste method. A quick check of the destination formula helps confirm that Excel did what you intended.

What You’ll Need

An Excel workbook with a formula cell and a destination cell or range.
Permission to edit the worksheet. If the sheet is protected, you may need the password or the worksheet owner’s help.
A clear idea of what should stay the same: the formula pattern, the exact formula text, or the cells the formula refers to.

Step-by-Step

Decide what you mean by exactly. If you are filling a calculation down a list, you usually want the same pattern with references that change row by row. If every copied formula must refer to one fixed input cell, use absolute references. If you need the same formula characters in the destination, copy the formula text rather than using an ordinary cell copy. These are different outcomes, so decide before you paste.
Inspect the source formula and its references. Select the cell and read the formula in the formula bar above the worksheet. A reference such as A2 is relative: Excel can change it when the formula moves. A reference such as $A$2 is absolute: both its column and row stay fixed when copied. A mixed reference, such as $A2 or A$2, fixes only one part. Identify which references should move and which should remain fixed before continuing.
For a normal copy, use copy and paste. Select the source cell, press Ctrl+C, select the destination cell, and press Ctrl+V. A moving dashed border appears around the copied cell until you cancel copy mode with Esc. To copy to a block, select the source, copy it, then select a destination block of the same dimensions and paste. Excel repeats the copied pattern across the selected area. On Mac, use Command+C and Command+V. On Excel for the web, the same shortcuts generally work, though browser or operating-system shortcuts can sometimes take priority.
Check the adjusted formula in the destination. With data in A2 and B2, where A2 contains 12 and B2 contains 5, the formula in C2 is =A2*B2, which returns 60. If A3 contains 8 and B3 contains 4, copying C2 down to C3 changes the formula to =A3*B3, which returns 32. This adjustment is expected: Excel moves relative references by the same number of rows or columns as the copied formula. Select C3 and inspect the formula bar if you want to verify the change.
Keep references fixed when that is the intended result. With a tax rate of 8% in B1 and a sale amount of 100 in A2, use =A2*$B$1 in C2; it returns 8. When copied down, the sale reference changes to the next row while the tax-rate reference remains B1. To change the reference style while editing a formula, select the reference and press F4 on Windows. Each press cycles through relative, absolute, and mixed forms. On Mac, Command+T commonly cycles the reference style; depending on the keyboard, Fn+F4 may also work. Check the formula bar because Mac keyboard settings can affect function keys.
Paste formulas without copying source formatting. Select and copy the source formula cell. Select the destination cell or range, then choose Home > Paste > Formulas from the Paste dropdown. Alternatively, open Home > Paste > Paste Special and choose Formulas in the dialog. This transfers formulas and relevant calculation results without applying the source cell’s formatting. References still adjust according to the destination; Paste Formulas does not lock them. If you also need the source formatting, use a regular paste or apply the formatting separately.
Copy the formula text when the characters must match. Select the source cell and click inside the formula bar. Select the entire formula text with the mouse, then press Ctrl+C on Windows or Command+C on Mac. Click the destination cell, click inside its formula bar, paste with Ctrl+V or Command+V, and press Enter. This copies the formula text as written, rather than asking Excel to translate the references based on a cell-to-cell copy. However, a relative reference such as A2 still means the cell at that address relative to the destination. If the destination must use the same original input cells, use absolute references before pasting the formula text.
Fill a formula across adjoining cells when appropriate. Select the formula cell and the cells below it, then choose Home > Fill > Down. For a horizontal range, choose Home > Fill > Right. In many layouts, you can also select the source and destination cells and press Ctrl+D to fill down, or Ctrl+R to fill right. On Mac, Command+D and Command+R are the common equivalents. Fill behaves like copying a formula: relative references adjust, and mixed or absolute references follow their reference rules. Use it for a consistent row-by-row or column-by-column calculation, not to preserve every source reference unchanged.
Confirm the result and save. Click the destination and check the formula bar, then compare the displayed result with the expected calculation. If the formula appears as text or shows an error, see Troubleshooting below. Save the workbook after verifying the copied area. If you filled a large range, check a cell near the beginning, one in the middle, and one at the end; an incorrect reference pattern can be hard to spot by looking only at the first result.

Common Mistakes

Expecting ordinary paste to preserve references. When a formula moves, Excel normally shifts relative references. This is the intended behavior for copied calculations, not a copying failure. Use dollar signs where a reference must stay anchored.
Locking every reference unnecessarily. If you make both row and column absolute, copying down a list may keep pointing at the original row instead of calculating each new row. Use a mixed reference when only the row or column needs to stay fixed.
Choosing Formulas and expecting formatting too. Paste Formulas transfers formula content, not the source cell’s full appearance. If borders, colors, or number formats matter, paste formatting separately or use regular paste when it is safe to do so.
Copying a displayed answer instead of the formula. If you copy a cell using a values-only option, the destination may contain a fixed number rather than a calculation. Inspect the formula bar to confirm the destination begins with a formula rather than merely showing a similar result.
Selecting the wrong destination range. Pasting a multi-cell selection into a range with a different shape can produce unexpected placement or an Excel warning. Match the destination dimensions to the copied range, or copy one formula cell and fill it into the intended range.
Editing the formula but not confirming it. When you paste into the formula bar, press Enter to commit the entry. Clicking another cell too soon can leave the edit incomplete or discard it. Check the destination after pressing Enter.

Tips

Use F4 while building formulas. In a formula being edited, select a cell reference and press F4 to cycle its reference style. For example, you can fix only the column when copying across, or only the row when copying down. This is quicker and less error-prone than inserting dollar signs by hand, but verify the final reference before filling a large range.
Keep source and destination positions in mind. A relative reference shifts by the same distance as the formula. Copying a formula three rows down moves a relative reference three rows down too; copying it one column right moves the reference one column right. That rule makes formula copying predictable once you know the offset.
Use the fill handle for a small, adjacent range. The small square at the lower-right corner of a selected cell is the fill handle. Drag it over adjacent cells to extend a formula pattern. This is convenient, but it can be difficult to control over long ranges. Double-clicking the fill handle may fill down beside a neighboring data column; check the ending row rather than assuming the range stopped where you intended.
Protect the original while trying alternatives. If the formula is complicated or important, copy it to a spare cell or make a workbook copy before changing its reference style. This gives you a quick comparison point if the result changes unexpectedly.
Distinguish copying from moving. Cutting and pasting a formula can affect references differently from copying it, because Excel may update references to follow moved cells. If the goal is to duplicate a calculation, use copy, not cut.
Remember that paste choices are separate from calculation behavior. Paste Special controls what content or formatting is transferred; relative, absolute, and mixed references control how references behave. Choosing Formulas does not make relative references absolute.

Troubleshooting

The destination points to the wrong row or column. Select the destination and inspect the references in the formula bar. If a reference should not have moved, edit the formula to add dollar signs to the row, column, or both, then copy again. If only one part needs to stay fixed, use a mixed reference rather than locking the whole address.

The destination shows the formula characters instead of a result. The cell may be formatted as Text, or the entry may have a leading apostrophe. Change the cell format to General, edit the cell, and press Enter again. Also check whether Show Formulas is enabled: press Ctrl+` on Windows to toggle it, or use Formulas > Show Formulas. The backtick key is often near Esc; keyboard layouts vary.

The copied result does not change after editing inputs. Excel may be set to manual calculation. Choose Formulas > Calculation Options > Automatic, then press F9 to recalculate. In Excel for Mac, use the Formulas tab to find Calculation Options; recalculation shortcuts can differ by keyboard and settings.

Paste Special is unavailable or the paste looks wrong. Make sure a cell has actually been copied, and that the destination is not in edit mode. Press Esc to exit cell editing, copy again, select the destination, and reopen the Paste dropdown. If the copied and destination ranges have different shapes, choose a single destination cell or select a matching range.

The workbook refuses the edit. A protected worksheet can prevent pasting into locked cells. Check Review > Unprotect Sheet if you are authorized to do so. If the workbook is shared, opened read-only, or in a restricted location, save an editable copy or ask the owner for permission.

Frequently Asked Questions

How do I copy a formula without changing its cell references?
Make the references absolute by adding dollar signs before the relevant column letters and row numbers. Then copy normally. If you need the formula text to match character for character, copy it through the formula bar, while remembering that relative references still resolve from the destination cell.

Does Paste Special > Formulas keep the original references?
No. It pastes formulas without the source formatting, but Excel still adjusts relative references for the new location. Use absolute or mixed references when particular rows or columns must remain fixed.

Can I copy a formula to another worksheet?
Yes. Copy the cell, switch to the destination worksheet, select the target cell, and paste. Relative references may shift based on the movement, and references to other worksheets may behave differently depending on how the formula is written. Inspect the formula bar and result after pasting.

How do I copy a formula but not its formatting?
Copy the source, select the destination, and choose Home > Paste > Formulas. The formula is pasted without the source cell’s formatting. Its relative references can still adjust.

Why does Excel change a formula when I drag the fill handle?
Excel treats the drag as filling a pattern. Relative references are adjusted for each new position, while absolute references stay fixed and mixed references lock only one dimension. Use the formula bar to verify a few filled cells.

Can I copy a formula exactly in Excel for the web or on Mac?
Yes. Copy and paste work in both, though shortcuts may differ: Command+C and Command+V are standard on Mac, and the ribbon Paste options are available in Excel for the web. The formula bar and reference-locking approach also work, but Mac function-key behavior can depend on keyboard settings.

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.