Formula Errors

Fix Excel for Mac Pasting Formulas as Values

Algirdas JasaitisAlgirdas Jasaitis Nov 22, 2026 868 views

Question details

The user needs copied formulas to remain formulas when pasted in Excel for Mac.

Fix Excel for Mac Pasting Formulas as Values
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.
Before you start

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.

Solution 1Recommended

Use standard Paste or Paste Special with Formulas

Use this method to check whether a paste option is replacing formulas with values.

1
Copy the formula cell

Select the cell containing the formula and press Command+C.

2
Paste the formula

Select the destination cell and press Command+V, or choose Edit > Paste. Avoid Paste Values.

3
Try Paste Special

If standard Paste still produces a value, choose Edit > Paste Special, select Formulas, and confirm.

4
Check the result

Select the pasted cell and inspect the formula bar. Change a referenced cell to verify that the result updates.

Use standard Paste or Paste Special with Formulas
Check cell references: Relative references normally change when a formula is pasted to a different location. Use absolute references such as $A$1 if a reference must stay fixed.
Free Microsoft Office alternative

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.

Copy and paste formulas in WPS SpreadsheetsCompatible with Microsoft Excel formats such as XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

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.