Office for Mac Issues

Fix Excel for Mac Pasting Values Instead of Formulas

Olivia MillerOlivia Miller Nov 18, 2026 869 views

Question details

The user needs to copy and paste formulas in Excel for Mac without pasting only their calculated values.

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

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.

Solution 1

Check the paste option in Excel for Mac

Use this quick check to rule out a values-only paste command.

1
Copy a formula cell

In Excel, select a cell that contains a formula and press Command+C.

2
Paste the formula

Select a destination cell and press Command+V, or choose Edit > Paste Special and select Formulas if that option is available.

3
Inspect the result

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.

Free Microsoft Office alternative

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.

Copy and work with formulas in WPS SpreadsheetsOpen and save Microsoft Excel formats, including XLSXUse a familiar spreadsheet interface for an easier transitionGet a free, lightweight office suite for everyday work
microsoft office alternative - wps office

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.