Why Is Paste Special Greyed Out in Excel for Mac? Causes and Fixes
Quick answer: Paste Special is greyed out in Excel for Mac when Excel has nothing it can paste special from. The usual causes are: you are still editing a cell, the copy was cancelled (the moving border is gone), the clipboard holds content from another app, or the sheet is protected. Press Escape, copy again with ⌘C, then try Cmd+Ctrl+V.
Symptoms
Edit ▸ Paste Special is greyed out
Cmd+Ctrl+V does nothing
Only a plain Paste is available
Paste Special works in one workbook but not another
Diagnostic table
| What you see | Most likely cause | Fix |
|---|---|---|
| Cursor blinking in a cell | Cell is in edit mode | Press Escape |
| No dashed border on the source | The copy was cancelled | Copy again with ⌘C |
| Copied from a browser or PDF | Limited paste formats | Paste as text, then format |
| Review tab shows Unprotect Sheet | Sheet protection | Unprotect or unlock the cells |
| A chart or shape is selected | Wrong selection type | Click a cell first |
Fixes, in order of probability
1. Leave cell edit mode
If the cursor is blinking inside a cell or the formula bar, Excel is editing text and Paste Special is not available. Press Escape, select the destination cell, and try again.
2. Copy again
The moving dashed border around the copied cells shows that Excel still holds the copy. If it has gone, copy again with ⌘C. Typing, pressing Return and most edits clear it.
3. Check where you copied from
When the content comes from another app, Excel offers fewer Paste Special options, and some can be greyed out. Paste it as plain text first, or copy from within Excel.
4. Check for sheet protection
On the Review tab, look at Protect Sheet. If the sheet is protected, pasting into locked cells is blocked until the protection is removed or the cells are unlocked.
5. Deselect objects and charts
If a chart or shape is selected, cell paste options are not available. Click a cell first.
6. Restart Excel and update
Quit Excel with ⌘Q, reopen it, and use Help ▸ Check for Updates. This clears stuck clipboard state.
Prevention
Copy and paste in quick succession, before anything clears the copy.
Use Cmd+Ctrl+V only when a cell, not text, is selected.
Learn the full set of paste shortcuts in Paste Values Shortcut in Excel for Mac (Plus Formulas, Formats and Transpose).
FAQs
Why does Paste Special not work in Excel for Mac?
Usually the copy was cancelled, or Excel is in edit mode. Press Escape and copy again.
What is the Paste Special shortcut on Mac?
Cmd+Ctrl+V. Microsoft also lists Ctrl+Option+V and Cmd+Option+V.
Does protection stop Paste Special?
Yes, on locked cells in a protected sheet.