Excel Copy and Paste Not Working? Causes and Fixes
By ExcelReady TeamUpdated 5 min read
The short answer
When copy and paste stops working in Excel, the cause is usually the selection or the sheet, not your keyboard. Check for a non-matching or multiple selection, a paste area of a different size, a filtered or protected sheet, merged cells or a spill range. If nothing pastes at all, copy again, clear the Office Clipboard and restart Excel.
Key takeaways
- Select one cell, the top-left corner of the target, before you paste. It avoids most size errors.
- The moving dashed border means Excel is ready to paste. Press Esc or type in a cell and it's gone, so copy again.
- Filtered lists copy only visible rows, but pasting into a filtered list can fill hidden rows too.
- Protected sheets, merged cells and spill ranges block pasting until you unprotect, unmerge or paste elsewhere.
- If pasted numbers won't add up, they probably landed as text. COUNTA minus COUNT tells you how many.
On this page+
When Excel copy paste is not working, the cause is almost always the selection or the sheet: a range that doesn't line up, a paste area of the wrong size, a filter, protection, merged cells or a spill range. Only rarely is the clipboard itself stuck. This guide goes through each cause with the message you'll see and the fix, starting with the most common.
Quick checklist#
Work down this list; most problems are solved in the first three steps.
| Symptom | Likely cause | Fix |
|---|---|---|
| Paste is greyed out | Copy mode ended | Copy again, then paste straight away |
| "This action won't work on multiple selections" | Ranges don't line up | Copy one block at a time |
| Copy and paste areas aren't the same size | Target selection is the wrong shape | Select one cell, then paste |
| "Microsoft Excel cannot paste the data" | Paste would run off the sheet | Paste whole rows into column A, whole columns into row 1 |
| Message about a protected sheet | Sheet protection | Unprotect the sheet |
| "We can't do that to a merged cell" | Merged cells in the target | Unmerge, or paste somewhere else |
| "You can't change part of an array" | Pasting into a spill range | Paste outside it |
| Data lands in hidden rows | Filtered or hidden rows | Paste into a sorted block |
| Numbers won't add up after pasting | Numbers pasted as text | Convert to numbers |
Paste is greyed out: copy mode has ended#
After you press Ctrl+C (Mac: ⌘C), Excel draws a moving dashed border around the copied cells. That border means Excel is ready to paste. If it disappears, there's nothing to paste and the Paste button greys out.
The border goes away when you press Esc, type in a cell, double-click to edit, or do some other actions such as inserting rows. The fix is simple: copy again, then paste before you do anything else. The copy, cut and paste lesson walks through this in a live sheet.
Multiple selections and different-sized areas#
Excel can copy several ranges at once only if they share the same rows or the same columns. Copying A2:A5 and C2:C5 together works. Copying A2:A5 and C7:C9 gives "This action won't work on multiple selections". Copy each block separately, or move the data so the blocks line up.
The paste area also has to match. If you copy 3 rows and then select 5 cells to paste into, Excel warns that the copy and paste areas aren't the same size. The easy fix: select only one cell, the top-left corner of where the data should go, and paste. Excel then fills the right-sized block from there.
A related error, "Microsoft Excel cannot paste the data", often appears when you copy entire columns and paste them anywhere but row 1, or entire rows and paste them anywhere but column A. The pasted block would run past the edge of the sheet. Select the first cell of the row or column and try again.
Filtered lists and hidden rows#
Filters change what gets copied and where it gets pasted:
- Copying from a filtered list copies only the visible rows. That's usually what you want.
- Copying with rows hidden by hand copies the hidden rows too. Select visible cells first with Alt+; (Mac: ⌘+Shift+Z). See how to select visible cells only.
- Pasting into a filtered list fills a continuous block, so values can land in the hidden rows between the ones you see.
To paste safely into a filtered list, sort the rows you want to change so they sit together, then paste. Or paste into a helper column on another sheet and pull the values across with a formula. The filter a table lesson shows how filters and SUBTOTAL work on visible rows.
Protected sheets, merged cells and spill ranges#
Three structures block pasting on purpose:
- Protected sheets. Locked cells can't change, and pasting is a change. Go to Review > Unprotect Sheet (you may need the password), or ask the file's owner to unlock the input cells. The guide to protecting sheets and locking cells explains how locking works.
- Merged cells. Pasting into a merged block that doesn't match the copied shape fails. Unmerge the target (Home > Merge & Center to toggle it off), or paste into normal cells.
- Spill ranges. A dynamic array formula, such as FILTER or UNIQUE, owns every cell it spills into. You can't paste into the middle of one. The article on the "can't change part of an array" error covers this in detail.
Pasted data looks wrong#
Sometimes paste works, but the result isn't what you expected:
- Formulas show different results. Relative references shift when you paste. A formula
=B2*C2copied down one row becomes=B3*C3. Use$to lock a reference, or paste values instead. - You wanted numbers, not formulas. Use Paste Special > Values: Ctrl+Alt+V then V on Windows, or Control+⌘+V on a Mac. See how to paste values only and when to use paste vs paste values.
- Numbers pasted as text. Data from emails, PDFs and websites often arrives as text. It sits on the left of the cell and SUM skips it.
You can spot text numbers with one formula. If B2:B7 holds six amounts:
=COUNTA(B2:B7)-COUNT(B2:B7)COUNTA counts every filled cell and COUNT counts only real numbers, so the difference is how many are text. In the exercise on this page, three of six amounts are text, so SUM returns 3,570 instead of the true 6,410. To fix them, select the cells, click the small warning icon and choose Convert to Number, or use Data > Text to Columns > Finish.
Nothing pastes at all: reset the clipboard#
If even a simple copy and paste in a new workbook fails, the clipboard or Excel itself is stuck. Try these in order:
- Clear the Office Clipboard. On Windows, open Home > Clipboard (the small arrow in the corner of the group) and click Clear All.
- Close other programs that use the clipboard, such as clipboard managers or remote desktop windows, then try again.
- Check Protected View. Files from email or the internet open read-only. Click Enable Editing on the yellow bar.
- Restart Excel. Save your work, close every Excel window and reopen.
- Start in safe mode (Windows): hold Ctrl while opening Excel and confirm. If copy and paste now works, an add-in is the likely cause. Turn add-ins off one at a time under File > Options > Add-ins.
In Excel for the web, the browser may block the right-click Copy and Paste commands. Use the keyboard shortcuts instead: Ctrl+C and Ctrl+V (Mac: ⌘C and ⌘V).
Practise it#
Most paste problems disappear once you know how Excel thinks about selections. Practise copy, cut and paste in a live spreadsheet: you copy formulas, watch references shift and move cells with cut, and each step is checked instantly. Then try the filter a table lesson to see how filtered rows behave when you count and copy.
Try it yourself
This is a live spreadsheet. Type the formula in the green cell and press Enter.
These invoice amounts were pasted from an email, and the total looks too low. In D2, count how many amounts in B2:B7 landed as text: subtract COUNT (numbers only) from COUNTA (all filled cells).
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Amount | ||||
| 2 | Pasted as text | ||||
| 3 | 980 | ||||
| 4 | |||||
| 5 | 760 | ||||
| 6 | 1100 | ||||
| 7 | |||||
| 8 | |||||
| 9 | |||||
| 10 |
Tip: COUNTA counts every filled cell. COUNT counts only real numbers. The difference is the text.
Practise this in a lesson
Frequently asked questions
Why is Paste greyed out in Excel?
Excel has lost what you copied. Pressing Esc, typing in a cell or some other actions end copy mode, so the dashed border disappears. Copy the cells again and paste straight away.
Why does Excel say this action won't work on multiple selections?
You copied ranges that don't line up, such as A2:A5 and C7:C9. Excel can copy several ranges only when they share the same rows or the same columns. Copy them one at a time instead.
Why can't I paste into a protected sheet?
Locked cells on a protected sheet can't be changed, and pasting is a change. Unprotect the sheet with Review > Unprotect Sheet, or ask the owner to unlock the cells you need.
Why does Excel paste into hidden rows?
Pasting fills a continuous block of cells, including rows hidden by a filter or by hand. Sort the target rows together first, or paste into a helper column and bring the values across with a formula.
Why do my pasted numbers not add up?
They were probably pasted as text. Text numbers sit on the left of the cell and SUM skips them. Select them and use the warning icon's Convert to Number option, or Data > Text to Columns > Finish.