If an Excel formula will not copy and paste correctly, first check whether the copied cell contains a formula, then use Home > Paste > Formulas or ordinary paste as needed. If the result is text, a value, or a different answer, check the cell format, calculation setting, and cell references; the right fix depends on what you see.
Identify what is going wrong
“Not working” can describe several different problems. A pasted cell might show the original answer instead of a formula, display the formula characters, return an unexpected result, or refuse to paste at all. These symptoms point to different causes, so inspect the destination cell before changing settings.
- It shows a number or date, but no formula: the source may have been copied as a value, or you may have chosen a values-only paste option.
- It shows an expression beginning with an equals sign: Excel may be treating the entry as text, or Show Formulas may be enabled.
- It calculates, but the answer is wrong: a relative reference may have shifted during copying, or a reference may need to be locked.
- Nothing pastes or Excel displays an error: check for protected cells, merged cells, an incompatible selection, or a blocked dynamic-array result.
Click the cell and inspect the formula bar above the worksheet. If it contains something such as =A2*B2, the cell has a formula even if the grid shows only its calculated result. If the formula bar contains only a number, the cell contains a value instead. This quick check prevents you from trying to repair a formula that is no longer there.
Understand how copied references change
Excel normally adjusts relative references when a formula is copied. That is useful when the same calculation should apply to each row, but it can look like a paste error if you expected the original cell addresses to stay fixed.
With quantities in A2:A3 and prices in B2:B3, put 12 in A2 and 5 in B2. Enter =A2*B2 in C2; it returns 60. Copy C2 to C3 and Excel changes the references to A3 and B3. If A3 contains 4 and B3 contains 7, C3 returns 28. The adjustment is normal: the formula keeps the same relative position to its new cell.
To keep a reference fixed, use dollar signs. With sales in B2:B10 and a tax rate of 8% in E1, enter =B2*$E$1 in C2. If B2 contains 100, the result is 8. Copy the formula down and the B-row reference changes, while $E$1 stays fixed. A reference such as E$1 locks only the row, and $E1 locks only the column; those mixed references are useful when copying across a grid.
On Windows, select a reference inside a formula and press F4 to cycle through its relative, absolute, and mixed forms while editing. On a Mac, the equivalent shortcut can depend on the keyboard and function-key settings; typing the dollar signs directly is reliable. If the formula copied successfully but points at an unintended cell, correct the reference style rather than repeatedly pasting.
Choose the right paste option
Ordinary copy and paste usually carries the formula along with other cell attributes. However, a paste option can deliberately leave out formulas. For example, Paste Values inserts the displayed results, not the calculations that produced them. That is useful for freezing a report or sending a fixed snapshot, but it is the wrong choice when you want a live formula in the destination.
To paste formulas in Excel for Microsoft 365 on Windows, copy the source, select the destination, then choose Home > Paste > Formulas. You can also right-click the destination and choose the formulas option under Paste Options. The exact icons can be easier to recognize by hovering over them for a tooltip. If you want a regular copy, use Ctrl+C and Ctrl+V on Windows; use Command+C and Command+V on Mac.
Use Paste Special when you need a particular combination rather than a complete cell copy. The dialog is available from Home > Paste > Paste Special; on Windows, Ctrl+Alt+V opens it. Options include formulas, values, formats, and other paste behaviors. In Excel for the web, the available options and their presentation can differ from the Windows desktop app, so use the Paste menu and confirm the resulting cell in the formula bar.
Also check that you copied the intended cell, not a nearby result or a cell that had already been pasted as values. A quick way to verify is to click the source before copying and inspect the formula bar. If the source contains a formula but the destination does not, repeat the paste using Formulas or ordinary paste rather than Values.
Fix formulas pasted as text
If the destination displays =A2*B2 literally instead of calculating it, the cell may be formatted as Text. Select the affected cells, choose Home > Number Format and set the format to General, then make Excel re-enter the formula. Changing the format alone may not convert an existing text entry into a working formula: select each affected cell, press F2, and then press Enter on Windows. On Mac, edit the cell and confirm the entry with Return or Enter, depending on the keyboard.
A leading apostrophe can also force an entry to be treated as text. Inspect the formula bar for an apostrophe before the equals sign. Remove it, then confirm the formula again. If many cells were affected, select a cell that has the correct formula and copy it, then paste formulas into the intended range; take care not to overwrite labels or other data.
Another possibility is that Show Formulas is on. This setting displays formulas in worksheet cells instead of their calculated results, which can make an entire sheet appear broken at once. Choose Formulas > Show Formulas to switch the view. If only one cell shows the expression while nearby cells show answers, text formatting or a leading apostrophe is more likely than this sheet-wide display setting.
Check calculation and refreshed results
A formula can paste correctly but continue showing an old answer if calculation is set to Manual. On Windows, check Formulas > Calculation Options and choose Automatic if you want Excel to recalculate formulas as inputs change. Press F9 to recalculate open workbooks, or Shift+F9 to calculate the active worksheet. On Mac, use the Formulas tab to check the calculation option; function-key behavior can vary with system settings.
Calculation mode affects whether formulas update promptly; it does not turn a pasted value back into a formula. Confirm the destination formula in the formula bar first. If the formula is present and the answer is stale, recalculate. If the formula bar shows only a fixed number, copy the original formula again.
Some formulas depend on external workbooks, data connections, or functions that recalculate under particular conditions. A pasted formula may therefore show an error or a result that differs from the source if its referenced data is unavailable or its inputs changed. Check the referenced cells and any links before assuming that the paste operation itself failed.
Resolve paste refusals and range problems
When Excel refuses to paste, inspect the destination and selection. A protected worksheet can prevent edits to locked cells; if you are authorized to change it, use Review > Unprotect Sheet and provide the password if requested. Do not try to bypass protection that belongs to someone else. Merged cells can also make source and destination ranges incompatible, particularly when their shapes differ.
For a multi-cell copy, select a destination range with a compatible shape, or select just the top-left destination cell and let Excel fill the matching area. Avoid copying a block into a differently sized selection unless you intend Excel to repeat the copied pattern. If a filtered list is involved, check which rows are visible and verify the pasted results afterward; a multi-cell paste into a filtered range may not behave like editing a simple uninterrupted block.
Dynamic-array formulas add another constraint. A formula that returns several results needs clear cells in its spill range. If another value, a merged cell, or another obstruction occupies that area, Excel can show a #SPILL! error. Clear the obstructing cells or move the formula to an open area. A cell inside an existing spill range is not an independent formula cell, so edit or copy the formula at the top-left of the spill range instead.
A reliable troubleshooting sequence
Work through these checks in order; they separate a copy problem from a reference, display, or calculation problem without changing more of the workbook than necessary:
- Click the source and destination cells and compare what appears in the formula bar.
- If the destination is a value, copy the formula source again and choose Home > Paste > Formulas.
- If the destination shows formula characters, check the number format, a leading apostrophe, and Formulas > Show Formulas.
- If the formula calculates to the wrong answer, inspect its relative, absolute, or mixed references and the input cells they point to.
- If the answer does not update, check Formulas > Calculation Options and recalculate.
- If pasting is blocked, check sheet protection, merged cells, selection size, and any spill range.
Before applying a repair to a large range, test it in one destination cell and verify both the formula and its result. If the workbook is important, save a copy before replacing many formulas. This is especially useful when a values-only paste or a broad fill operation could overwrite data that is difficult to reconstruct.
Frequently Asked Questions
Why does Excel paste the result instead of the formula?
If the destination contains a fixed number rather than an expression in the formula bar, the source may be a value or the paste option may have been Paste Values. Copy a cell that still contains the formula and choose Home > Paste > Formulas.
Why does my formula change when I copy it down?
Excel adjusts relative references to match the new row or column. That is expected for formulas such as a row-by-row multiplication. Add dollar signs to references that must remain fixed, such as $E$1.
Why is the formula visible instead of its answer?
Check whether the cell is formatted as Text, starts with an apostrophe, or the worksheet has Show Formulas enabled. Set a text-formatted cell to General and re-enter its formula; toggle Show Formulas off if formulas are visible throughout the sheet.
Why does a copied formula show an old value?
The workbook may be using Manual calculation. Check Formulas > Calculation Options and choose Automatic, or recalculate with F9 on Windows. First confirm that the destination contains a formula rather than a pasted value.
Why can’t I paste into a cell?
The sheet may be protected, the destination may be part of a merged range, or the copied and selected ranges may be incompatible. A dynamic-array spill range can also block edits to its output cells. Check the specific message and destination before changing the worksheet structure.
Related
- Copy and Paste X Times in Excel: Repeat Cells or Rows
- Convert H:M:S to a Number in Excel
- Contact Number List Template for Excel: Setup Guide
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Why Are My SUMIFS Not Working? Excel FixesWhen SUMIFS is not working in Excel, the most common causes are mismatched range sizes, criteria that do…
- Excel Error Sound: Why It Plays and How to Stop It in WindowsExcel’s error sound is usually an Office feedback beep or a Windows system sound triggered when you perform…
- Excel Dropdown List Not Showing? Fix the ArrowIf an Excel dropdown list is not showing, select the cell and check Data > Data Validation: make…
- Excel Date Input: Enter and Fix Dates That Won’t ParseIn Excel for Microsoft 365 on Windows, enter a date in a format your regional settings recognize, such…
- Data Validation Error in Excel: Causes and FixesA data validation error in Excel means an entry does not meet a rule set for that cell,…
- Excel #NAME? Error in IF: Causes, Checks, and FixesIn Excel, #NAME? means the formula contains text Excel cannot recognize as a valid function, defined name, or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.