Fix Excel for Mac Pasting Values Instead of Formulas
Question details
The user needs to copy and paste formulas in Excel for Mac without pasting only their calculated values.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Copying a cell containing a formula and pasting it into another cell.
- Observed behavior
- The destination cell may contain only the calculated value rather than the formula.
Select the source cell and check the formula bar to confirm that it contains a formula beginning with an equals sign. Note whether you use a clipboard manager or recently installed endpoint security software.
Check the paste option in Excel for Mac
Use this quick check to rule out a values-only paste command.
In Excel, select a cell that contains a formula and press Command+C.
Select a destination cell and press Command+V, or choose Edit > Paste Special and select Formulas if that option is available.
Select the destination cell and check the formula bar. A pasted formula may show adjusted cell references, but it should still begin with an equals sign.
Test formula copying in Mac Safe Mode
Use Safe Mode to check whether software loaded during a normal startup may be interfering with Excel's clipboard data.
Investigate clipboard tools and security software
Use these checks if the problem occurs during normal startup or began after a background application was installed.
Work with spreadsheet formulas in WPS Office for Mac
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets and continue working with formulas as you move between office suites.

Frequently Asked Questions
Why does Excel paste a number instead of my formula?
A values-only paste option can cause this, as can interference with clipboard data from another application. Try Command+V or Edit > Paste Special > Formulas, then check the destination cell's formula bar.
What does it mean if formulas paste correctly in Safe Mode?
It suggests that software or settings involved in a normal startup may be contributing. Restart normally, then investigate clipboard utilities, login items, and endpoint security software.
Can a clipboard manager interfere with Excel formulas?
Yes. Quit the clipboard manager using its menu bar controls and repeat the Excel copy-and-paste test. If the issue stops, check for an update to the utility.
Why did the cell references change after I pasted a formula?
Excel normally adjusts relative references when a formula is pasted to a new location. Select the destination cell and inspect the formula bar; adjusted references do not mean the formula was pasted as a value.
What should I do if security software caused the problem?
Share the timing and your test results with your IT department. Ask whether the endpoint protection product has an update or patch rather than changing managed security settings yourself.





