Formula Errors

How to Fix Excel Formulas Pasted as Plain Text or Values

Huma Ashraf Ch Oct 10, 2026 871 views

Question details

The user needs to know how to correctly paste actual formulas instead of plain text or static values when copying cells.

Fix Excel Formulas Pasting as Plain Text or Values

Product: Excel
Device & OS: not provided
Scenario: Copying and pasting formula-driven data between cells or workbooks.
Observed behavior: Excel pastes the calculated static value or plain text representation into the destination cell instead of the original dynamic formula.

Before you start

Ensure that the destination cell is formatted as 'General' rather than 'Text', as pasting a formula into a text-formatted cell will force it to display as raw text instead of calculating.

Solution 1Recommended

Use the Paste Special Feature to Preserve Formulas

Manually instructing Excel to paste only the formulas prevents it from defaulting to plain text or values when pasting from the clipboard.

When you copy a cell, Excel stores multiple formats on your clipboard. Using Paste Special guarantees that the internal formula format is selected instead of the simpler text representation.

Copy the source cell

Select the cell containing the formula you want to duplicate and press Ctrl+C or right-click and choose Copy.

Open the Paste Special menu

Right-click the destination cell where you want the formula to appear. Instead of a standard paste, select 'Paste Special' from the context menu.

Select the Formulas option

In the Paste Special dialog box, click the radio button next to 'Formulas' and click OK to apply.

Keyboard Shortcut: You can quickly access this by pasting normally (Ctrl+V) and immediately pressing Ctrl to open the Paste Options menu, then pressing F for Formulas.

Solution 2

Copy the Formula Directly from the Formula Bar

This method extracts the raw formula text directly, bypassing any clipboard formatting issues caused by third-party applications or multiple Excel instances.

Efficient Spreadsheet Management

Preserve Formulas Effortlessly with WPS Spreadsheet

WPS Spreadsheet provides precise and reliable clipboard controls to ensure your complex calculations are pasted exactly as intended. Avoid unexpected formatting conversions easily with robust Paste Special options.

1. Open your workbook in WPS: Launch WPS Office and open your spreadsheet document containing the formulas.
2. Copy the formula cell: Select the cell containing your formula and press Ctrl+C to copy it.
3. Use Paste Special: Right-click the target cell, hover over 'Paste Special', and select 'Formulas' from the expanded menu.

100% compatible with Microsoft Excel (.xlsx) formats and formulasDedicated Paste Options menu to explicitly retain calculationsFree, lightweight, and fast-loading for daily office tasksSeamless cross-workbook copying with a unified tabbed interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel paste the calculated value instead of the formula?

This usually happens if you copy data from an external application or a completely different instance of Excel that only transfers the plain-text value to the clipboard. It can also occur if you accidentally selected 'Paste Values' from the Paste Options menu.

How do I stop my pasted formulas from showing up as raw text?

If a formula shows as raw text (e.g., '=A1+B1' displays instead of the numeric result), the destination cell is likely formatted as 'Text'. Select the cell, change its format to 'General' in the Home tab, click into the Formula Bar, and press Enter to recalculate it.

Can I copy formulas between completely different workbooks?

Yes, but to ensure formulas transfer correctly without converting to static text or values, both workbooks must be opened within the same instance or window of the spreadsheet application.

Excel & Data Problems