How to Paste Formulas in Excel Without Changing Them

Formulas & functions · Updated November 20, 2026

To paste a formula into another cell without Excel adjusting its cell references, copy the formula text from the formula bar and paste that text into the destination cell. For a formula you plan to copy repeatedly, make the references absolute first with dollar signs; ordinary copy-and-paste and Paste Special > Formulas both adjust relative references.

What You’ll Need

  • Microsoft Excel for Microsoft 365 on Windows, or a version of Excel with a formula bar and a worksheet.
  • The source cell containing the formula and the destination cell or cells.
  • If you will copy a formula to many cells, a clear idea of which references should stay fixed and which should move.

You do not need to change an Excel setting or install an add-in. The key is to choose between preserving the exact formula text and allowing Excel to adapt references for the new position. Those are different goals, and the right method depends on how the formula is written and where you are putting it.

Step-by-Step

  1. Check the formula and decide what must stay the same. Select the source cell and read the formula in the formula bar above the worksheet. Check each cell reference. A relative reference such as B2 can change when copied; an absolute reference such as $B$2 is designed to stay fixed. Decide whether you need an identical formula string or just a formula that produces the right result in a new location.
  2. For one formula, copy its text from the formula bar. Click the source cell, then click inside the formula bar. Select the complete formula, including its first equals sign. On Windows, press Ctrl+C. You can drag across the formula text to select it; if you use Ctrl+A, make sure the formula bar has focus so you select the formula rather than worksheet cells. On Mac, use Command+C after selecting the formula text.
  3. Paste the formula text into the destination cell. Click the destination cell in the worksheet, paste with Ctrl+V on Windows or Command+V on Mac, and press Enter. Excel enters the formula text as a formula, but it does not apply the usual copy-cell adjustment to its references. Check the formula bar in the destination cell to confirm that the references match the original.
  4. Use absolute references if you will fill or copy the formula. If a reference must always point to the same cell, edit the source formula so that reference has dollar signs before the column and row. For example, with a unit price in B2 and a fixed multiplier of 1.1 in F1, the formula is =B2*$F$1. With B2 containing 12 and F1 containing 1.1, the result is 13.2. The B2 reference is still relative, so it can change as you fill down; $F$1 stays fixed.
  5. Use F4 to switch a reference style while editing. Click the formula cell and click the reference in the formula bar or edit the formula in the cell. Place the insertion point in or beside the reference, then press F4 to cycle through relative, absolute, and mixed reference styles. For example, Excel cycles among B2, $B$2, B$2, and $B2. On many laptops you may need Fn+F4; on Mac, the key combination can depend on your keyboard settings, and you can type the dollar signs directly if the function key behaves differently.
  6. Copy the adjusted formula normally when that suits the task. Once fixed references are absolute, copy the source cell and paste or fill it into the destination range. On Windows, use Ctrl+C and Ctrl+V, or drag the fill handle at the lower-right corner of the selected cell. On Mac, use Command+C and Command+V. Review a few destination formulas to ensure the fixed references remain fixed and any intended relative references have moved appropriately.
  7. For several different formulas, repeat the formula-bar method for each one. Copy each source formula as text and paste it into its corresponding destination cell. This is slower than copying a whole range, but it preserves each formula’s references exactly. Keep a source-to-destination list or work across one row at a time if the range is large, so formulas do not end up in the wrong cells.
  8. Confirm the result, not just the displayed number. Select each pasted cell and inspect its formula bar. Compare the reference text with the source formula, then check that the result makes sense. A formula can look unchanged but still refer to an unintended cell if a reference was already incorrect in the source. If a cell displays the formula characters instead of a calculated result, see Troubleshooting below.

When copying a block of formulas, note that Excel treats each cell’s formula separately and normally shifts relative references according to the destination. The formula-bar technique is most practical for a small number of cells. For a larger block, first decide whether absolute references or a redesigned formula can preserve the intended logic, then copy the range and inspect representative cells.

Common Mistakes

  • Assuming Paste Special prevents reference changes. In Excel for Microsoft 365 on Windows, Home > Paste > Formulas pastes formulas without the source formatting, but it does not freeze relative references. A formula copied from C3 to C4 can still be adjusted. Use absolute references or paste the formula text if you need the original reference text unchanged.
  • Adding dollar signs to every reference without considering the calculation. Absolute references are useful for fixed inputs, such as a tax rate or multiplier, but not every reference should be locked. If a row-by-row formula is supposed to use B2, B3, and B4 as it fills down, locking the row or column can make every result point to the wrong input.
  • Copying the result instead of the formula. Copying a cell and choosing a values-only paste transfers the displayed result, not a working formula. Use the formula bar when you need an exact formula, or use a normal formula paste when adjusted references are wanted.
  • Leaving an apostrophe at the start. An apostrophe can make Excel treat an entry as text. That is useful if you want to display formula characters without calculating them, but it is not the way to paste a working formula. A working formula normally begins with = and should not have an apostrophe before it.
  • Overwriting existing destination cells. Pasting a formula replaces what is in the selected cell. Check the destination range first, especially if the worksheet contains data or formulas that must be kept. Consider making a copy of the sheet before a large set of changes.

Tips

  • Use the right reference type. A reference like $B$2 locks both column and row. $B2 locks the column but lets the row change; B$2 locks the row but lets the column change. Mixed references are helpful when filling a formula across a table.
  • Remember that moving and copying are different. Copying a cell usually adjusts relative references in the pasted copy. Cutting and moving a cell is intended to relocate it, not make a duplicate, and can affect other formulas that refer to the moved cell. Do not use cut-and-paste as a substitute for copying an unchanged formula.
  • Use the formula bar for a one-off exact duplicate. It avoids having to rewrite all the references with dollar signs when the destination is far away. It is especially useful when a formula contains a mix of relative and absolute references that you need to preserve exactly.
  • Test with a spare cell first. Paste one formula into an empty test cell and inspect the formula bar before applying the method to a full range. This catches accidental text entry, an incomplete selection, or an unwanted reference change early.
  • Keep a backup for important workbooks. Before replacing many formulas, save a copy or use Save As. Undo can reverse ordinary paste actions, but a saved backup is safer if you make several edits or discover the problem later.
  • On Excel for the web, verify the interface. The formula bar and common copy-and-paste commands are available in Excel for the web, though menu labels and keyboard behavior can vary by browser. If selecting formula text in the formula bar is awkward, use absolute references for repeatable copying or open the workbook in the desktop app.

Troubleshooting

The destination formula changed its references. This usually means you copied the cell itself, which tells Excel to adjust relative references. Undo the paste with Ctrl+Z on Windows or Command+Z on Mac, then either copy the formula text from the formula bar or add dollar signs to the references that must remain fixed and paste normally.

The destination shows the formula instead of a result. Check whether the pasted entry has a leading apostrophe, whether the cell is formatted as Text, or whether Show Formulas is on. Remove an unintended apostrophe, change the cell format to General, and re-enter the formula by selecting the cell, pressing F2, and then pressing Enter. To toggle Show Formulas in Windows Excel, use Ctrl+` (the grave-accent key, often beside 1); on Mac, the shortcut may differ by keyboard, so use the Formulas tab’s Show Formulas command if available.

The pasted formula gives an error or an unexpected number. Compare its references with the source and confirm that the destination has the same relevant input cells available. A formula copied exactly can still return an error if its original references do not make sense from the new location, or if it depends on a relative reference that was meant to move. Decide whether exact text or correct destination-specific logic is the priority, then adjust references accordingly.

Only part of the formula was pasted. Return to the source cell, click the formula bar, and make sure the selection includes the initial equals sign and the entire expression. Copy again, select the destination cell itself, paste, and press Enter. Avoid double-clicking into the destination’s formula bar unless you specifically intend to edit its existing contents.

F4 does not change the reference style. Make sure the cell is in edit mode and the insertion point is on a cell reference. On a laptop, try Fn+F4. If the key still controls a system function, type dollar signs directly around the column and row parts that need to be fixed.

Frequently Asked Questions

Does Paste Special > Formulas keep references unchanged?
No. It pastes formulas without carrying over the source cell’s formatting, but Excel still adjusts relative references for the new location. Use formula text from the formula bar for a one-off exact copy, or use absolute references where appropriate.

How do I copy a formula without changing its cell references?
For one formula, select and copy the formula text in the formula bar, then paste it into the destination cell and press Enter. For repeated copying, lock the references that should stay fixed with dollar signs, while leaving references that should move as relative.

Can I paste a formula as text instead of calculating it?
Yes. Enter an apostrophe before the equals sign or format the destination cell as Text before entering the formula. Excel will display the formula characters rather than calculate them. To make it calculate later, remove the apostrophe or change the format to General and re-enter the formula.

Will copying a formula to another worksheet keep the same references?
Not necessarily. Normal copying can adjust relative references, and references to other sheets may be rewritten depending on the formula and destination. To preserve the exact formula text, copy it through the formula bar. Then confirm that sheet names and referenced cells exist and are still the intended targets.

Can I use this method for a whole range of formulas?
You can copy each formula from its formula bar into its matching destination, but that is manual. For a large range, consider whether absolute or mixed references will make an ordinary range copy safe. Paste a small sample first and inspect the formulas before filling the rest.

Does the method differ on Mac or Excel for the web?
The underlying reference behavior is the same: copying a cell can adjust relative references. On Mac, use Command+C and Command+V instead of Ctrl+C and Ctrl+V, and use dollar signs directly if F4 is intercepted by the keyboard. Excel for the web supports formulas and the formula bar, but its controls can vary slightly by browser.

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.