Do one quick test first. Copy a line of text from your browser and paste it into Notepad or an email. If that works but Excel still won’t cooperate, the fault is inside Excel and this page is for you. If copy and paste is broken everywhere, it’s a system problem instead. Start with our guide to copy and paste not working, or the one for Windows 11if that’s your machine.
Why is copy and paste not working in Excel?
Most of Excel’s error messages point straight at the cause. Find yours on the left.
| Cause | Fix | |
|---|---|---|
| “This action won’t work on multiple selections” | Ctrl-selected ranges in different rows and columns | Copy one block at a time |
| “We can’t do that to a merged cell” | Merged cells in the copy or paste area | Unmerge, or paste Values |
| “Copy area and paste area aren’t the same size” | The paste target is a different shape | Click one cell, then paste |
| “The cell or chart you’re trying to change is on a protected sheet” | Sheet protection | Review, Unprotect Sheet |
| Yellow Protected View bar | File opened read-only | Click Enable Editing |
| “No clipboard access” in a browser | Browser blocks the clipboard | Allow Clipboard for the site |
| “Compatibility Mode” in the title bar | An old .xls file with fewer rows and columns | File, Info, Convert to .xlsx |
| Nothing happens at all | An add-in or a stuck clipboard | Safe mode, clear the Office Clipboard |
What does “This action won’t work on multiple selections” mean?
You held Ctrl and picked more than one range, and Excel can’t fit them into one rectangle. Older versions say “That command cannot be used on multiple selections” instead. Excel pastes a multi-part selection by sliding the pieces together, so they have to share rows or columns. Microsoft’s explanation gives the rule. A1, A3 and A5 copy fine because they sit in one column. A1 plus B2 fails, because Excel can’t tell which way to slide them.
The fix is to copy each block on its own, or pick ranges that line up. If you only clicked once and still see the message, press Esc to drop any leftover selection. Then check the sheet tabs. If several tabs are highlighted, the sheets are grouped. Right-click a tab and choose Ungroup Sheets.
Why does Excel refuse to paste into merged cells?
If you see “We can’t do that to a merged cell,” merged cells are the reason. When you merge cells, Excel treats the whole block as a single cell. Copying a normal range onto, or out of, merged cells creates a shape mismatch, and Excel refuses to guess what you meant.
To fix it, select the area, then on the Home tab open the Merge & Center arrow and choose Unmerge Cells. Do this for both the cells you are copying from and the cells you are pasting into. Then paste again. If the layout has to stay merged, copy your data and use Paste Special with the Values option, which drops in just the contents.
“The copy area and paste area aren’t the same size”
This one means you selected a block to paste into that doesn’t match the block you copied. Copy three rows, select five, and Excel stops. The easy fix is to click a single cell, the top-left corner of where the data should go, and paste there. Excel fills out the rest.
If it still fails with one cell selected, look for hidden trouble. The Excel support team points at merged cells somewhere in the source sheet, which you can clear by pressing Ctrl+A twice and choosing Unmerge Cells. Grouped sheets and an active filter can cause it too. So can pasting a full row from a new .xlsx file into an old .xls file, which has fewer columns.
How do you use Paste Special in Excel?
A lot of Excel paste trouble is pasting the wrong part. Excel copies everything by default: the value, the formula behind it, the formatting, the borders, the conditional rules. Paste Special lets you pick only the part you want.
Copy your cells, then press Ctrl+Alt+V, or right-click the destination and choose Paste Special. The options that matter most:
- Values pastes the numbers and text only, with no formulas. This is the fix when formulas break or show errors after a paste.
- Formulas brings the formulas without the source formatting, so the result fits your existing sheet.
- Formatting copies the look without the contents, handy for matching styles across sheets.
- Transpose flips rows into columns and back, which saves a lot of manual retyping.
Why does Excel paste hidden rows from a filtered list?
Copy a filtered list and paste it somewhere else, and the hidden rows can come along. Microsoft says so plainly: “the hidden cells are pasted along with the visible ones.” To copy only what you can see, select the range and press Alt+;(or go to Home, Find & Select, Go To Special, Visible cells only). Then copy and paste as usual.
Pasting intoa filtered range is the harder case. Excel has no paste option that skips hidden rows, so a block pasted over a filtered list can land in rows you can’t see. Clear the filter and sort the rows you want together first. Excel for the web doesn’t offer the visible-cells-only option at all, unless your data is formatted as a table.
Protected sheets and Protected View
A protected sheet blocks pasting into locked cells, and every cell is locked by default. You’ll see “The cell or chart you’re trying to change is on a protected sheet.” Go to the Review tab and choose Unprotect Sheet. If it asks for a password, you need it from whoever set it. Some sheets also stop you from selecting locked cells, which makes it look like copy is broken. Protect Workbook is a different lock. It only covers the sheet tabs (adding, moving or deleting sheets), so it won’t stop a paste into cells.
Files from email or the internet often open in Protected View, which Microsoft calls “a read-only mode where most editing functions are disabled.” You can’t paste into it. If you trust the file, click Enable Editing on the yellow bar. If the bar is red, the option is under File, Edit Anyway.
Copy and paste not working in Excel for the web
In a browser, Excel needs your permission to use the clipboard. If it’s blocked, you get a “No clipboard access” message, or copy and cut just act strangely. Microsoft’s fix for Chrome and Edge is the same idea in both. Click the site information icon at the left of the address bar, find Clipboard, and set it to allowed. Then reload the page.
Keyboard shortcuts are the reliable path in the browser. Ctrl+C, Ctrl+X and Ctrl+V work even where the ribbon buttons don’t. Microsoft’s browser notes say Firefox has to let JavaScript use the clipboard before the ribbon’s Copy and Paste buttons work. Pasting from the desktop app into the web version can also lose formulas and formatting, because the browser passes along less.
Copy and paste not working in Excel 2016, 2019 or older
The fixes on this page work the same in Excel 2016, 2019 and 2021 as in Microsoft 365. Older versions word a few errors differently, but the causes are the same. Two problems come up more often on older copies of Excel.
The first is an old file format. Files saved as .xls (Excel 97 to 2003) hold 65,536 rows and 256 columns. A current .xlsx sheet holds 1,048,576 rows by 16,384 columns. Copy a whole row or column from a new file into an old one and it won’t fit, so Excel says the copy area and paste area aren’t the same size. If the title bar says Compatibility Mode, you’re in an old-format file. Go to File, Info, Convert to save it as .xlsx, then paste again. Or copy just the cells that hold data.
The second is damaged Office files. If copy and paste fails in Excel and Word but works everywhere else, repair Office. Right-click Start, choose Installed apps, find Microsoft Office, choose Modify, and pick Quick Repair. If that doesn’t help, run Online Repair, which takes longer and fixes more.
Office 2016 and Office 2019 stopped getting updateson October 14, 2025. So a bug that appears in those versions now won’t get a fix from Microsoft. If you hit a paste problem that none of the steps here solve, that’s a good reason to move to a current version.
What do you do when Ctrl+C and Ctrl+V do nothing in Excel?
If there’s no error and simply nothing happens, work through these in order. Most people are fixed by the second or third.
1. Clear the Office Clipboard
Excel has its own clipboard on top of the Windows one. It holds up to 24 items and is shared with Word, Outlook and the other Office apps. On the Home tab, click the small arrow in the corner of the Clipboard group to open the Office Clipboard, then click Clear All. Copy and try again.
The Office Clipboard only covers Office apps and stops at 24 items. If you want to get back to something you copied last week, a clipboard manager like Relic keeps everything you copy and lets you search it later.
2. Start Excel in safe mode to rule out add-ins
Add-ins are the biggest cause of Excel-only copy and paste failures, because they can hook into the same actions you are using. Close Excel. Then press Win+R, type excel /safe and press Enter. You can also hold Ctrl while you open Excel and confirm the prompt. Safe mode starts Excel with add-ins switched off. If copy and paste works now, an add-in is to blame. Go to File, Options, Add-ins, manage the COM Add-ins, and turn them all off. Turn them back on one at a time to find the culprit.
3. Close whatever else is watching the clipboard
Other programs can hold the Windows clipboard for a moment every time you copy. Remote desktop tools, screen capture apps, password managers and clipboard managers are the usual ones. Close the other Office apps too. Then quit these one at a time and test after each.
4. Restart Excel, then the machine
A clean restart of Excel clears a surprising number of stuck states. If that doesn’t do it, a full reboot resets the Windows clipboard as well, which matters when the problem is not really Excel at all.
5. Restart the clipboard process (Windows)
When pasting is broken in every Windows app, restart Windows Explorer from Task Manager. If you work over Remote Desktop, the process to restart is rdpclip.exe, which carries the clipboard between your machine and the remote one. End it in Task Manager, then start it again with Win+R and rdpclip, since it doesn’t come back on its own. The Windows 11 guide has the rest of the system-level fixes.
Other Excel-specific gotchas
- Two different Excel windows. Copying between separate Excel instances sometimes loses the clipboard. Open both files in the same Excel window so they share one clipboard.
- Dragging instead of copying.If the fill handle and drag-to-copy stopped working, re-enable it under File, Options, Advanced, “Enable fill handle and cell drag-and-drop.”
If the problem is bigger than Excel
When the same failure shows up in every app, Excel is just the messenger. A stuck key, a background tool grabbing the shortcut, or a clipboard process that needs a restart can all break the basics. Our guides on copy and paste not working, Ctrl C and Ctrl V not working and copy and paste not working on Windows 11 cover those causes step by step. You can also check what’s actually on your clipboard with Windows clipboard history (Win+V), which tells you whether the copy even registered.
Sources
- Move or copy cells and cell contents, Microsoft Support
- That command cannot be used on multiple selections, Microsoft Learn
- The information cannot be pasted because the Copy area and the Paste area are not the same size and shape, Microsoft Excel Support Team Blog
- Merge and unmerge cells, Microsoft Support
- Copy visible cells only, Microsoft Support
- Protect a worksheet, Microsoft Support
- What is Protected View?, Microsoft Support
- Troubleshoot copy and paste errors in Office for the web, Microsoft Support
- Copy and paste in Office for the web, Microsoft Support
- Copy and paste multiple items by using the Office Clipboard, Microsoft Support
- Open Office apps in safe mode on a Windows PC, Microsoft Support
- Excel specifications and limits, Microsoft Support
- Repair an Office application, Microsoft Support
- Ending Support in 2025, Microsoft Learn