Fix Paste Special Values Disabled in Excel for Mac
Question details
The user needs to restore or diagnose the unavailable Paste Special > Values command in Excel for Mac.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS Ventura 13.1
- Scenario
- The user is copying spreadsheet content and wants to paste values only into an Excel worksheet.
- Observed behavior
- Paste Special > Values is grayed out even though the relevant Excel settings appear to be correct.
Copy a normal, unlocked cell range from within Excel and identify an ordinary unlocked destination range. Note whether the source is a worksheet range, image, protected object, or content copied from another application.
Copy a normal Excel range and open Paste Special again
Use this method when Paste Special Values is disabled because the copied content does not support value-only pasting.
Excel enables Paste Special options according to the copied content, source application, and destination range. A standard cell range copied from an Excel workbook provides the most compatible test case.
In Excel for Mac, select a normal range containing cells, then choose Edit > Copy or press Command+C.
Click an ordinary, unlocked cell or range in the destination worksheet. Avoid protected sheets, charts, images, and embedded objects.
Choose Edit > Paste Special, then check whether Values is available. You can also press Command+Control+V to open the Paste Special dialog.
Select Values in the Paste Special dialog and click OK to insert the cell results without the original formulas or formatting.
Test another workbook and remove source or destination restrictions
Use this diagnostic path when a normal range still does not enable Paste Special Values.
Switch to WPS Office for Reliable Values-Only Spreadsheet Pasting
If Excel for Mac continues to disable Paste Special Values based on the copied object or workbook state, WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface. You can open compatible Excel files, copy standard cell ranges, and paste values without changing your existing workflow.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the application launcher.
- 2. Open the Excel workbook: Choose Menu > Open and select the compatible .xlsx or .xls file you want to edit.
- 3. Copy the source cells: Select a normal cell range and choose Home > Copy or press Command+C on Mac.
- 4. Open paste options: Select the destination cell, choose Home > Paste, and select the values-only paste option when available.
Frequently Asked Questions
Why is Paste Special > Values grayed out in Excel for Mac?
Excel determines available Paste Special options from the copied content, source application, and destination range. Images, protected objects, external formats, and unsupported selections may not provide a Values option.
What keyboard shortcut opens Paste Special on Excel for Mac?
Copy the cells with Command+C, select the destination, and press Command+Control+V. You can also open Edit > Paste Special from the macOS menu bar.
Can a protected worksheet disable Paste Special Values?
Yes. A protected sheet or locked destination range can restrict paste operations. Test the command in a new, unprotected worksheet or check Review > Unprotect Sheet in the original workbook.
Does copying from another application affect Paste Special options?
Yes. Content copied from a browser, image editor, PDF, or another external application may be treated as an image or external format, so Excel may not offer Values. Copy a normal cell range from an Excel workbook instead.
