How to Fix Excel Pasting Values Instead of Formulas
Question details
The user needs to restore the default functionality of copying and pasting formulas using keyboard shortcuts or the context menu in Microsoft Excel.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Copying cells that contain formulas to duplicate their calculations in other rows, columns, or worksheets.
- Observed behavior
- Excel pastes only the calculated static values instead of the underlying formulas, and the context menu displays fewer paste options than usual.
Ensure you are not accidentally triggering a 'Paste Special > Values' macro or shortcut. Save your workbook and try completely closing and reopening the application before making advanced configuration changes.
Check Calculation Settings and Disable Conflicting Add-ins
This is the most common fix. It ensures your workbook is set to calculate automatically and isolates any third-party add-ins that might be hijacking the clipboard.
If Excel is set to Manual calculation, formulas might appear as if they pasted as values because they don't update. Additionally, COM or Excel add-ins can intercept the standard Ctrl+C/Ctrl+V commands, limiting your paste options.
Go to the Formulas tab on the ribbon, click on 'Calculation Options', and select 'Automatic'.
Close Excel entirely. Press and hold the Ctrl key, then click the Excel shortcut to open it. Confirm you want to start in Safe Mode.
Try copying and pasting a formula in Safe Mode. If it works correctly, the issue is caused by an add-in.
Go to File > Options > Add-ins. At the bottom, manage 'Excel Add-ins' and 'COM Add-ins'. Uncheck all add-ins, restart Excel normally, and enable them one by one to find the culprit.
Reset the Home Ribbon Tab
Use this solution if your paste options are missing from the ribbon or right-click context menu.
Repair Your Microsoft Office Installation
If settings and add-ins are not the cause, the core Office configuration files may be damaged and require a built-in repair.
Experience Glitch-Free Spreadsheets with WPS Office
Tired of troubleshooting clipboard bugs and broken add-ins in Microsoft Excel? Switch to WPS Spreadsheet. It provides a highly stable, lightweight environment where essential features like copying and pasting formulas work flawlessly every time.
- 1. Download and Install: Get WPS Office from the official website and run the quick installer.
- 2. Open Your Workbook: Double-click your existing .xlsx file to open it in WPS Spreadsheet with perfect formatting.
- 3. Copy and Paste Seamlessly: Use Ctrl+C and Ctrl+V normally; WPS instantly copies and intelligently adjusts your formulas.
Frequently Asked Questions
Why does Excel only show the 'Paste Values' option?
This happens when Excel loses access to its internal clipboard memory, often intercepted by third-party background software (like PDF creators or communication tools), forcing Excel to treat the copied content as plain text.
Can a protected worksheet prevent formulas from being pasted?
Yes. If the destination cells are locked and the worksheet is protected, Excel restricts complex pasting operations. You need to navigate to the Review tab and click 'Unprotect Sheet' before pasting.
Does clearing the Windows Clipboard history fix Excel pasting issues?
It can. Overloaded clipboard managers sometimes cause software conflicts. Press Windows Key + V to open the clipboard history, click 'Clear all', and try copying your formula in Excel again.
