Stop Excel for Mac from Adding Equal Signs to Pasted Data
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.
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.
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.
Launch Excel for Mac, click Excel in the macOS menu bar, and select Preferences.
In the Excel Preferences window, select Edit to view automatic editing options.
Clear the Automatically create calculated columns checkbox.
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.
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. Install WPS Office: Download and open WPS Office, then launch WPS Spreadsheets.
- 2. Open your workbook: Select Open from the home screen and choose the existing XLS or XLSX workbook.
- 3. Paste the data: Click the destination cell and paste the space-separated text, then review the result before saving.

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.




