Fix Excel for Mac Paste Special and Format Painter Problems
Question details
The user needs to restore normal copying, Paste Special, and formatting behavior in Excel for Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Copying worksheet cells or worksheets, pasting formulas and formatting, or using Format Painter.
- Observed behavior
- Paste Special may show only text-based options, formulas may paste as text, formatting may be lost, or copying worksheets may fail.
Open a workbook in Excel for Mac and identify any clipboard managers or security tools running on the Mac. If the Mac is managed by your organization, contact IT before changing security software.
Check clipboard managers and retest Excel
Use this when Paste Special shows text-only options or copied cells lose formulas or formatting.
Excel displays different Paste Special options depending on how it recognizes the macOS clipboard contents. Clipboard managers can interfere with recognition of native worksheet content, especially when they are outdated.
From the menu bar or each app's menu, temporarily quit clipboard managers such as CopyPaste Pro, Copy'em, Clippy, or CopyClip 2.
Choose Excel > Quit Excel, then reopen Excel and your workbook.
Select a cell containing a formula or formatting, choose Edit > Copy, select another cell, and choose Edit > Paste Special. Check whether worksheet options such as Formulas and Formats are available.
Select a formatted cell, click Format Painter on the Home tab, and apply it to another cell. If copying now works, update the clipboard utility before using it again.

Check security software for clipboard restrictions
Use this if the problem remains after clipboard managers are closed, especially on a managed Mac.
Work with spreadsheet formatting in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Excel format compatibility helps you move existing workbooks into WPS Spreadsheets, though it does not fix clipboard restrictions in Excel.

Frequently Asked Questions
Why does Excel for Mac show only text options in Paste Special?
Excel may not recognize the clipboard contents as native worksheet data. Quit any clipboard manager, restart Excel, copy a cell again, and check Edit > Paste Special.
Can a clipboard manager cause formulas to paste as text?
Yes. A clipboard utility can interfere with the worksheet data Excel places on the clipboard. Temporarily quit it from its menu, restart Excel, and test copying a formula cell.
Could Forcepoint affect copying in Excel?
Forcepoint or another data-loss-prevention tool may control clipboard transfers. On a managed Mac, ask your IT administrator to check the relevant clipboard policy rather than disabling the tool yourself.
Will changing Excel's calculation mode fix Paste Special?
Changing calculation mode from Automatic to Manual and back will not normally fix clipboard interception. Check clipboard utilities and security policies instead.




