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 seeMost likely causeFix
Cursor blinking in a cellCell is in edit modePress Escape
No dashed border on the sourceThe copy was cancelledCopy again with ⌘C
Copied from a browser or PDFLimited paste formatsPaste as text, then format
Review tab shows Unprotect SheetSheet protectionUnprotect or unlock the cells
A chart or shape is selectedWrong selection typeClick 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.

Cut does not work with Paste Special

One cause catches many people: Paste Special only works after a copy. If you pressed ⌘X to cut instead of ⌘C, Excel simply moves the cells, and the Paste Special command stays greyed out. Copy with ⌘C, then open Paste Special. If your goal was to move cells, a normal paste after cut is the right tool.

Other places Paste Special can be unavailable

  • The workbook is read-only or in Protected View. If Excel is not allowing edits, paste commands are limited until you enable editing.

  • The destination does not match. Pasting a column of values into a filtered range or into merged cells can be blocked or behave differently.

  • You are in a dialog or the formula bar. Anything that keeps focus away from the grid has the same effect as edit mode.

Other ways to reach the same command

If the keyboard shortcut does nothing but you can copy normally, try a different route. On the Home tab, open the arrow under Paste and choose Paste Special, or right-click the destination cell. Microsoft also lists Ctrl+Option+V and Cmd+Option+V as alternatives to Cmd+Ctrl+V, which helps if one combination is intercepted by another app.

A quick triage order

Work through these in order and stop when Paste Special comes back: press Escape, copy again with ⌘C, click a cell rather than a chart, check Protect Sheet on the Review tab, then restart Excel.

Prevention

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.

Why is Paste Special greyed out after I cut cells?

Paste Special only works after a copy. After a cut, Excel just moves the cells. Copy with ⌘C instead.

Can a read-only file stop Paste Special?

Yes. If the workbook is read-only or in Protected View, editing commands are limited until you enable editing.

← Back to all articles

Mac Excel Shortcuts: Excel shortcuts not working on Mac? Alt E S V, Paste Values, the Windows way. Try it free for 7 days.