Copy the Exact Same Formula in Excel Without Changing It

Formulas & functions · Updated November 20, 2026

To copy the exact same formula text in Excel, select the formula in the formula bar, copy it, then paste it into the destination cell’s formula bar and press Enter. A normal cell copy usually adjusts relative references, so use this method when every destination must contain the identical formula rather than a version adapted to its new position. If you want references to stay fixed while copying normally, make them absolute with dollar signs instead.

What You’ll Need

  • A workbook open in Excel for Microsoft 365 on Windows.
  • The source cell that contains the formula you want to repeat.
  • The destination cell or cells where the formula should be entered.
  • If the formula refers to other cells, confirm that using those same references in every destination is actually what you want. An identical formula can return different results only if the referenced values or context differ; it can also return the same result repeatedly if it points to the same inputs.

Step-by-Step

  1. Check what the formula does before copying it. Click the source cell and read the formula bar above the worksheet. Decide whether you need the formula text to stay exactly the same, or whether you only want the same calculation pattern in each row. Those are different outcomes. For instance, a formula that refers to row 2 normally changes to refer to row 3 when copied one row down. If that change is useful, ordinary copying is the right method. If not, continue with the formula-bar method.
  2. Select the source cell and enter its formula bar. Click the cell once, then click inside the formula bar. The formula bar is the long entry area above the column letters and worksheet grid. You should see the formula beginning with an equals sign. Do not select the cell’s displayed result in the grid; you need to copy the formula itself.
  3. Select the complete formula text. In the formula bar, drag across the formula from the initial equals sign through the final character. Make sure the selection includes the entire expression and does not include only part of a cell reference, a closing parenthesis, or another character. If the formula is long, enlarge the formula bar by dragging its lower edge or use the expand control at its right side, if shown.
  4. Copy the selected text. On Windows, press Ctrl+C. You can also right-click the selected formula text and choose Copy. Keep the source cell unchanged. If Excel is in cell-edit mode rather than the formula bar, press Esc and click the formula bar again before copying; otherwise you may copy a cell or selection instead of the formula text.
  5. Choose the destination cell. Click the cell where the identical formula should go. If you are copying to a distant cell, use the Name Box to the left of the formula bar: type a cell address such as D8 and press Enter. You can also move to the destination with the arrow keys. Avoid selecting a range at this point if you are not familiar with entering formulas into multiple cells at once; first confirm the process in one destination cell.
  6. Paste into the destination formula bar. Click inside the formula bar for the destination cell and press Ctrl+V. Verify that the complete formula appears there and begins with =. Press Enter to commit it. The destination now contains the same formula text, including the same cell references, operators, function names, and punctuation as the source.
  7. Check the result and the formula text. Click the destination cell and compare what appears in its formula bar with the source formula. The displayed result may be different if the formula uses a context-sensitive function or if workbook settings affect calculation, but the expression should match character for character. If it does not, undo the entry with Ctrl+Z and repeat the selection and paste carefully.
  8. Repeat for other destinations. For each destination, click its formula bar, paste the copied formula, and press Enter. If there are many destinations, you can keep the formula text on the clipboard while doing this, but copying anything else will replace the clipboard contents. For a large group, consider whether absolute references or a formula designed to work across the whole range would be clearer and easier to maintain.

Here is a small example of what an identical formula means. Assume B2 contains 12 and C2 contains 5. The source cell D2 contains =B2*C2. The formula multiplies the values in B2 and C2, so D2 displays 60. If you paste that exact formula into D3 using the formula bar, D3 also contains =B2*C2 and still calculates from B2 and C2. It does not change itself to use B3 and C3. That behavior is the point of preserving the exact formula, but it may not be what you want for a row-by-row calculation.

If your real goal is to copy a calculation down a list while keeping one input fixed, use an absolute reference instead. Assume B2 contains 12, C2 contains 5, and F1 contains 2. In D2, enter =B2*$F$1. The result is 24. When you copy that cell down one row normally, Excel adjusts B2 to B3 but keeps F1 fixed, giving a row-specific calculation multiplied by the same value in F1. The dollar signs lock both the column and row of F1. This is often a better choice than pasting an identical formula into every row.

Common Mistakes

  • Using Ctrl+C and Ctrl+V on the cell, then expecting its references to stay unchanged. A regular copy is designed to adjust relative references. For a source formula that refers to B2, a copy one row down will generally refer to B3. Paste Special > Formulas also copies formulas while adjusting relative references; it does not force the formula text to remain identical.
  • Confusing identical formulas with identical results. The same formula text can produce different results if it depends on a relative position, the active row, or changing values. Conversely, the same formula pasted repeatedly may show the same result because every copy refers to the same inputs.
  • Copying the displayed value instead of the formula. A cell usually displays a calculated result, not the expression itself. Select the text in the formula bar, rather than copying a number you can see in the grid.
  • Leaving off the equals sign or part of the expression. Pasting an incomplete expression may produce an error or enter text instead of a working formula. Check the first and last characters before pressing Enter.
  • Using a formula-bar paste for a long range without checking the result. It is easy to paste into the wrong cell or overwrite existing content. Test in one cell, verify it, and then continue. Save the workbook first if the destinations contain important data.

Tips

  • Use F4 to lock references when you want a reusable formula pattern. While editing a formula, select or place the cursor on a cell reference and press F4 to cycle through relative, absolute, and mixed-reference forms. For example, an absolute reference uses dollar signs before both the column and row. On some laptops, you may need Fn+F4. On Mac, the equivalent depends on the keyboard and system settings; try Command+T while editing a reference, or use the function-key setting for F4.
  • Use the formula bar for exact text, not Paste Special. In Windows Excel, Home > Paste > Formulas is useful for copying formulas without formatting, but it still applies normal relative-reference changes. Do not treat it as a way to freeze the source formula’s text.
  • Keep a source formula in a convenient place. If you must reuse one exact expression in several nonadjacent cells, copy it once and paste it into each destination formula bar before copying anything else. Alternatively, keep a written record of the expression so it can be re-entered if the clipboard is replaced.
  • Make the intended behavior clear to future users. If repeated formulas all point to one set of inputs, add a nearby label or note explaining why. Otherwise, someone may assume the formulas are meant to calculate separately for each row and change them later.
  • On Mac, use the same formula-bar selection method. The usual copy and paste shortcuts are Command+C and Command+V rather than Ctrl+C and Ctrl+V. The formula itself behaves the same way. In Excel for the web, click the formula bar and select and copy the text; browser shortcuts or focus can differ, so check that the formula bar—not the worksheet cell—is active before pasting.

Troubleshooting

The destination changed to a nearby row or column. You likely copied the cell normally rather than copying text from the formula bar. Undo with Ctrl+Z, return to the source, select the whole formula in the formula bar, and paste into the destination formula bar. If you actually want a copied formula to adjust by row or column, use ordinary copying instead.

The cell shows the formula as text instead of calculating it. Check whether the destination cell is formatted as Text or whether an apostrophe was entered before the equals sign. Set the cell format to General using Home > Number Format > General, then re-enter the formula in the formula bar and press Enter. Changing the format alone may not convert a formula that Excel already stored as text, so re-entry is important.

Excel reports a formula error after pasting. Compare the pasted expression with the source, looking for a missing parenthesis, operator, or reference. Also check whether the formula refers to a sheet or workbook that is unavailable. If the formula uses a function not supported by your Excel version, the exact copy will still be identical but may not calculate correctly in that version.

The formula bar does not accept the paste. Click directly in the formula bar, not merely in the destination cell, and confirm that the insertion point or selected text is visible there. Press Esc to leave an accidental edit state and try again. In Excel for the web, browser focus can intercept shortcuts; click the formula bar and use its context menu to paste if the keyboard shortcut does not reach Excel.

The result is the same in every copied cell, but that was not intended. This indicates that the formula was indeed preserved with the same references. Undo the entries and copy the source cell normally, or edit it to use absolute references only for the inputs that should remain fixed. Test the first copied result before filling the rest of the range.

Frequently Asked Questions

Does Ctrl+C and Ctrl+V copy the exact same formula in Excel?
It copies the cell, but Excel normally adjusts relative references based on the destination. To retain identical formula text, copy the expression from the formula bar and paste it into the destination formula bar.

Does Paste Special > Formulas keep cell references unchanged?
No. It pastes formulas without other cell formatting, but relative references generally adjust to the destination just as they do with a normal formula copy. Use the formula bar to repeat exact text, or use absolute references when only particular references need to stay fixed.

How can I copy the same formula down a column and have it calculate each row?
Copy the formula cell normally with the fill handle or Ctrl+D. Excel adjusts relative references for each row. Use dollar signs on any reference, such as a tax rate or constant cell, that should remain fixed. Verify the first and last copied formulas to make sure the references shifted as intended.

Can I enter the identical formula into several selected cells at once?
Yes. Select the destination range, type or paste the formula, then press Ctrl+Enter on Windows to enter the same formula in all selected cells. This is useful when the formula should literally repeat, but first confirm that every cell should refer to the same inputs. On Mac, the equivalent key combination can vary with the Excel version and keyboard; use the Excel shortcut help for your installation if Command+Return does not work.

Will the identical formula always return the same result?
No. Its result depends on the values and workbook context it evaluates. Some formulas also depend on the cell where they are entered or on calculation settings. Compare the formula text separately from the calculated result when checking whether it was copied exactly.

Can I do this in Excel for the web or on a Mac?
Yes. The formula-bar method works in both, although controls and keyboard shortcuts can differ. Use Command+C and Command+V on Mac in place of the common Windows Ctrl shortcuts. In the web app, make sure the formula bar has focus before copying or pasting, since browser shortcuts may otherwise act on the page.

Related

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.