Fix Limited Paste Special Options in Excel for Mac
Question details
The user needs to restore the expected Paste Special options in Excel for Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user copies cells within Excel and opens Paste Special to choose how to paste them.
- Observed behavior
- The Paste Special dialog shows only limited options, even though the copied cells appear in the clipboard.
Note which Paste Special options are missing and whether the issue occurs when copying between cells in the same workbook. Check whether any clipboard managers or other clipboard utilities are running.
Disable Clipboard Utilities and Test a New Workbook
Use this test to check whether a clipboard utility or a workbook-specific issue is limiting the available paste options.
Find any third-party clipboard manager or utility in the macOS menu bar and use its Quit or Disable command temporarily.
In Excel, choose File > New Workbook and enter a value and a formula in separate cells.
Select the test cells and choose Edit > Copy. Select another cell, then choose Edit > Paste Special and check the available options.
Repeat the copy and Paste Special test in the original workbook. If options return after disabling a utility, check that utility's clipboard settings before re-enabling it.

Update and Restart Excel and macOS
Use this approach if Paste Special remains limited after checking clipboard utilities.
Collect Version Details for Microsoft Support
Contact Microsoft Support if the problem persists after the clipboard, update, and restart checks.
Try WPS Spreadsheet for Everyday Paste Special Tasks
WPS Office is a free, lightweight alternative with a familiar interface and support for Microsoft Office formats, making it easier to move existing spreadsheets into a different workspace.

Frequently Asked Questions
Why does Paste Special show limited options when I copy cells within Excel?
A clipboard utility, macOS clipboard behavior, or an Excel issue may affect the options shown. Quit third-party clipboard utilities and test Edit > Paste Special in a new workbook.
How do I update Excel for Mac?
In Excel, choose Help > Check for Updates. If you installed Excel through the Mac App Store, open the App Store and check its Updates section.
Does updating Excel always fix the Paste Special dialog?
No. If the issue remains after an update, restart Excel and macOS, disable clipboard utilities temporarily, and test in a new workbook.
What should I provide to Microsoft Support?
Share your Excel version from Excel > About Microsoft Excel, your macOS version from Apple menu > About This Mac, the missing options, recent system changes, and the results of your tests.




