If pasting a formula in Excel is not working, first check whether the destination cell is formatted as Text, whether Excel is showing formulas instead of results, and whether calculation is set to Automatic. Select the destination, choose Home > Number Format > General, paste the formula again, and press Enter; if the formula still does not calculate, work through the checks below.
What should happen when you paste a formula?
When you copy a cell containing a formula and paste it into another cell, Excel normally copies the formula and adjusts its cell references for the new location. The displayed result may look just like a number or a date, but the formula bar should show the expression when you select that cell. For example, copying a formula one column to the right usually shifts its relative references one column to the right as well.
Excel also copies other cell properties during an ordinary paste, including formatting. That can make a copied formula appear not to work: the destination might inherit a number format that hides decimals, or it might show a date serial as a date. To paste only the calculation, use Home > Paste > Paste Special > Formulas. This keeps the formula but avoids transferring the source cell’s formatting.
First distinguish between three different outcomes: the formula is visible as text, the cell shows an unexpected result, or the paste command does not put anything in the target cell. Each points to a different cause, so select the pasted cell and inspect both the formula bar and the displayed value before changing anything.
Check whether Excel is displaying formulas
If many cells show expressions such as =A1+B1 instead of their calculated values, Excel may be in Show Formulas mode. This is a worksheet display setting, not a problem with each pasted formula. On Windows, open the Formulas tab and check Show Formulas. Turn it off to return to the usual results view. The keyboard shortcut is Ctrl+` (the grave accent key); on a Mac, the shortcut can vary with keyboard layout, so use Formulas > Show Formulas if the key combination is unclear.
There is a useful way to tell this apart from a formula stored as text: Show Formulas generally affects formulas throughout the sheet, while a text-formatted entry usually affects only particular cells. Column widths may also expand when Show Formulas is on, because formulas are longer than their results. Turning the view off does not alter the formulas or their values.
Fix a formula pasted as plain text
A cell formatted as Text treats a pasted expression as characters rather than as a calculation. Select the affected cells and choose Home > Number Format > General. Then re-enter the formula: select each cell, press F2, and press Enter. Merely changing the number format after pasting may not convert existing text into a working formula; re-entering it prompts Excel to interpret the contents again.
Also look for an apostrophe or leading space before the equals sign. An entry such as an apostrophe followed by =A1+B1 is deliberately stored as text. Remove the extra character and confirm the entry again. If an entire column has the same problem, select it, change its format to General, and use Find and Replace or a careful re-entry process; check a few cells first so you do not unintentionally alter labels or other text.
For a quick test, type a simple expression directly into a blank General-formatted cell. With 4 in A1 and 6 in B1, enter =A1+B1 in C1; the expected result is 10. If that works, the formula engine is functioning and the issue is more likely the pasted cell’s format, contents, or references.
Choose the right paste option
Excel offers several paste behaviors, and the one you need depends on what you are copying. After copying, open Home > Paste or right-click the destination to see options. Paste normally includes formulas and formatting. Paste Values keeps the displayed results rather than the formulas. Paste Formulas transfers calculations without the original formatting. A common source of confusion is selecting Paste Values when the goal is to keep an editable formula.
On Windows, Ctrl+C copies and Ctrl+V pastes. To open Paste Special, use Ctrl+Alt+V, then select the desired option in the dialog. You can also use Home > Paste > Paste Special and choose Formulas or Values. On Mac, use Command+C and Command+V; Paste Special is available from the Home tab or the Edit menu, though keyboard shortcuts depend on the keyboard and Excel version. In Excel for the web, use the ribbon’s Paste options; available shortcuts can also be affected by the browser.
Check that the copied cell actually contains a formula. If its formula bar shows a fixed number rather than an expression, pasting it as a formula cannot restore the original calculation. Similarly, copying from a web page, PDF, or another application may put text on the clipboard rather than a native Excel cell. In that case, paste into Excel, inspect the result, and re-enter or rebuild the formula rather than assuming Excel received a formula object.
Understand reference changes after pasting
A formula can paste successfully but return a different result because relative references move with the formula. Suppose a formula in C2 refers to A2 and B2. Pasting it into C3 ordinarily changes those references to A3 and B3. That behavior is usually helpful when filling down a list, but it can break a calculation that must always point to one fixed cell.
Dollar signs make a reference absolute or partly fixed. With a tax rate in F1, a formula copied down a column can keep referring to F1 by using an absolute reference. With quantities in A2:A4 and a unit price in F1, enter =A2*$F$1 in B2 and copy it to B4; if F1 contains 5 and A2:A4 contain 2, 3, and 4, the results are 10, 15, and 20. The row reference changes as the formula moves, while the absolute reference remains fixed.
In a mixed reference such as $A2, the column stays fixed while the row can change; in A$2, the row stays fixed while the column can change. Select the reference inside the formula and press F4 on Windows to cycle through reference styles. On a Mac, F4 may require the Fn key, depending on keyboard settings. If a pasted formula points to the wrong cells, compare its references with the source formula before replacing it.
Check calculation settings and formula results
If a cell contains a valid formula but its displayed result does not update after an input changes, check calculation mode. On Windows, go to Formulas > Calculation Options and select Automatic. Manual calculation can leave results unchanged until Excel recalculates. Press F9 to recalculate open workbooks; on Mac, use Formulas > Calculate Now or the available calculation shortcut for that version.
Calculation mode is different from a paste failure. The formula may be present and correct, but its result is stale because Excel has not recalculated. Conversely, if the formula bar shows plain text or a pasted value, changing calculation mode will not turn that content into a formula. Diagnose the cell contents first, then check calculation if the expression is present but the answer seems out of date.
Errors such as #REF!, #VALUE!, and #NAME? also mean something different from a failed paste. #REF! commonly indicates a reference that no longer points to a valid cell; #VALUE! can indicate an incompatible value or argument; and #NAME? can mean Excel does not recognize text in a formula as a valid name or function. Select the cell and inspect the expression, references, and any error tooltip before editing it.
Look for sheet, range, or compatibility restrictions
A protected worksheet can prevent edits in locked cells. If Excel refuses to paste or reports that the cell is protected, check Review > Unprotect Sheet; a password may be required. Protection is separate from the workbook’s calculation settings. If the sheet is protected intentionally, ask its owner to unlock the target cells rather than trying to bypass the restriction.
Merged cells, filtered ranges, and multi-cell selections can also make paste behavior confusing. A copied block and the selected destination need compatible shapes in many paste operations. Try copying one formula cell and pasting it into one ordinary, unmerged cell. If that succeeds, expand the range in smaller steps and check whether the original selection, merged layout, or filtered rows explain the difference.
Formulas copied from a newer Excel version may use functions unavailable in an older version or another spreadsheet program. Excel 2021 and Microsoft 365 include functions such as XLOOKUP and FILTER; other functions have their own version requirements. An unsupported function can produce an error even though the paste worked. Also, Excel’s argument separator may differ by regional settings: if a formula copied from another locale uses commas but the destination expects semicolons, adjust separators to match the local Excel configuration.
A reliable troubleshooting sequence
When the cause is not obvious, use a small, controlled test rather than repeatedly pasting over the original data. Keep a backup copy of important workbooks before making broad changes, especially when using Find and Replace or filling a large range.
- Select one affected cell and inspect the formula bar. Decide whether it contains a formula, plain text, or a fixed value.
- Check Formulas > Show Formulas. If the whole sheet displays expressions, turn that view off.
- If the formula is text, set the cell to General and re-enter it with F2, then Enter.
- Try Home > Paste > Paste Special > Formulas when you need the calculation but not the source formatting.
- Compare cell references with the source formula, and add dollar signs where a reference must remain fixed.
- If the expression is correct but its result is stale, set calculation to Automatic and recalculate.
- If pasting is blocked, test an unmerged cell and check whether the worksheet is protected.
This sequence helps identify whether the issue is display, stored content, reference movement, recalculation, or a worksheet restriction. Once one test works, apply the same fix to the larger range and verify a few results before relying on them.
Frequently Asked Questions
Why does Excel show the formula instead of the answer?
Show Formulas may be enabled, or the cell may be formatted as Text. Turn off Formulas > Show Formulas if expressions appear across the sheet. For an isolated cell, change its format to General and re-enter the formula.
Why does a pasted formula show a different answer?
Excel adjusts relative references when a formula moves. Compare the source and destination formulas in the formula bar. Use dollar signs to lock references that must continue pointing to the same cell.
How do I paste only the formula and not formatting?
Copy the source cell, select the destination, then choose Home > Paste > Paste Special > Formulas. This transfers the calculation without carrying over the source cell’s formatting.
Why is my formula result not updating?
Check Formulas > Calculation Options and select Automatic. If the formula is present and correct but the value is stale, recalculate with F9 on Windows or use the calculation command on the Formulas tab.
Can I paste a formula from Google Sheets or a website?
Sometimes, but clipboard content may arrive as text, and functions or argument separators may differ. Paste into a test cell, inspect the formula bar, and confirm that Excel supports the function and recognizes the syntax before using it across a workbook.
Related
- Excel Redo Shortcut: How to Repeat an Action in Excel
- Excel Insert Row Shortcut: Steps for Windows and Mac
- MS Excel Open: How to Launch and Start a Workbook
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Duplicate Values Not Working in Excel? How to Fix ItIf Excel is not highlighting duplicate values, first select the full range you want to check, then choose…
- SUMIFS Not Working With Blanks? Fix the CriteriaWhen you want to sum rows whose criteria cells are blank, use an explicit empty-string criterion: with categories…
- Strikethrough in Excel: Add It, Remove It, and Fix ItTo apply strikethrough in Excel for Microsoft 365 on Windows, select the cell or cells and press Ctrl+5;…
- Jupyter Notebook: How to Split a Cell and Fix Common IssuesTo split a Jupyter Notebook cell, click inside it where you want the break, then choose Edit >…
- Excel Workbook Link Broken? How to Fix ItIf an Excel workbook link is broken, first identify whether you mean an external-workbook reference in a formula…
- Excel File Open in Another Application Error: FixesIf Excel says a file is open in another application, first close the workbook everywhere it may be…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.