Office for Mac Issues

Stop Excel for Mac from Adding Equal Signs to Pasted Data

Huma Ashraf ChHuma Ashraf Ch Nov 12, 2026 868 views

Question details

The user needs to prevent Excel for Mac from adding equal signs when space-separated text is pasted into a worksheet.

Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
Pasting space-separated text into Excel and wanting it to remain plain text instead of being interpreted as calculated data.
Observed behavior
Excel for Mac may automatically add equal signs and treat the pasted content as calculated data.
Before you start

Open Excel for Mac and make sure the workbook containing the pasted data is available. If possible, test the setting with a small sample of the space-separated text before pasting the full data set.

Solution 1Recommended

Disable automatic calculated columns in Excel for Mac

Use this solution when Excel adds equal signs to pasted, space-separated text and you want the content treated as plain text.

1
Open Excel Preferences

Launch Excel for Mac, click Excel in the macOS menu bar, and select Preferences.

2
Open the Edit settings

In the Excel Preferences window, select Edit to view automatic editing options.

3
Clear calculated columns

Clear the Automatically create calculated columns checkbox.

4
Paste the data again

Close Preferences and paste the space-separated content into the worksheet again. Excel should now treat it as plain text rather than automatically adding equal signs.

Formulas must be entered manually: After this setting is cleared, Excel will no longer automatically create calculated columns. Enter formulas manually whenever calculated results are needed.
Free Microsoft Office alternative

Paste worksheet data cleanly with WPS Office

If Excel for Mac keeps interpreting pasted text as formulas or calculated data, WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface, strong Microsoft Office format compatibility, and a simple migration path for existing workbooks.

  1. 1. Install WPS Office: Download and open WPS Office, then launch WPS Spreadsheets.
  2. 2. Open your workbook: Select Open from the home screen and choose the existing XLS or XLSX workbook.
  3. 3. Paste the data: Click the destination cell and paste the space-separated text, then review the result before saving.
Paste and edit spreadsheet data in a familiar worksheet interfaceLightweight alternative for handling text and calculated dataCompatible with Microsoft Excel XLS and XLSX formatsSupports seamless migration from existing Microsoft Office workbooks
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel for Mac add equal signs to pasted text?

Excel may interpret space-separated pasted content as calculated data and automatically create calculated columns, which can add equal signs to the entries.

Where is the setting that controls automatic calculated columns?

Open Excel, choose Excel from the macOS menu bar, select Preferences, open Edit, and clear Automatically create calculated columns.

Will clearing this option disable formulas in Excel?

No. It only stops Excel from creating calculated columns automatically. You can still enter formulas manually in worksheet cells.

Do I need to restart Excel after changing the preference?

A restart is generally not required. Close Preferences and paste the data again to check whether Excel now keeps it as plain text.