Fix Excel for Mac Pasting Formulas as Values
Question details
The user needs copied formulas to remain formulas when pasted in Excel for Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Copying and pasting cells that contain formulas.
- Observed behavior
- Some pasted cells contain fixed calculated values instead of formulas, so changes to referenced cells do not update them.
Select a pasted cell and check the formula bar: a formula begins with an equals sign, while a fixed value does not. Note that a formula normally displays its calculated result in the cell.
Use standard Paste or Paste Special with Formulas
Use this method to check whether a paste option is replacing formulas with values.
Select the cell containing the formula and press Command+C.
Select the destination cell and press Command+V, or choose Edit > Paste. Avoid Paste Values.
If standard Paste still produces a value, choose Edit > Paste Special, select Formulas, and confirm.
Select the pasted cell and inspect the formula bar. Change a referenced cell to verify that the result updates.

Test a new workbook and disable Excel add-ins
Use a simple test to determine whether the behavior is specific to a workbook or an add-in.
Check Excel calculation settings
Use this check if a pasted formula is still present but its displayed result does not update.
Work with Spreadsheet Formulas in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working with formulas as you migrate your documents.

Frequently Asked Questions
How can I tell whether a pasted cell contains a formula?
Select the cell and look at the formula bar. If it shows an expression beginning with =, the formula is present; if it shows only a number, the cell contains a value.
Why did my formula's cell reference change after pasting?
Excel adjusts relative references based on the destination. Use an absolute reference, such as $A$1, when the reference must remain fixed.
Does manual calculation turn formulas into values?
No. Manual calculation can leave displayed results unchanged until recalculation, but it does not normally remove formulas. Check Excel > Preferences > Calculation to change the setting.
What should I do if formulas paste correctly in a new workbook?
Compare the original workbook with the test workbook and check its paste behavior. You can also disable add-ins through Tools > Excel Add-ins and test again.




