Office for Mac Issues

Fix Limited Paste Special Options in Excel for Mac

Khadija KhanKhadija Khan Nov 20, 2026 869 views

Question details

The user needs to restore the expected Paste Special options in Excel for Mac.

Fix Limited 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.
Before you start

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.

Solution 1Recommended

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.

1
Quit clipboard utilities

Find any third-party clipboard manager or utility in the macOS menu bar and use its Quit or Disable command temporarily.

2
Create a test workbook

In Excel, choose File > New Workbook and enter a value and a formula in separate cells.

3
Test Paste Special

Select the test cells and choose Edit > Copy. Select another cell, then choose Edit > Paste Special and check the available options.

4
Compare the results

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.

Disable Clipboard Utilities and Test a New Workbook
Options depend on the copied content: Paste Special choices can vary with the source and type of content copied. For a consistent test, copy cells directly within Excel.
Free Microsoft Office alternative

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.

Use Paste Special options for common spreadsheet editing tasksOpen and edit Microsoft Excel XLSX and XLS filesWork in a familiar spreadsheet interfaceUse a free, lightweight Office alternative
microsoft office alternative - wps office

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.