Copy and paste works everywhere until it does not, and Excel is the place it fails most creatively. Sometimes nothing happens at all. Sometimes you get the famously unhelpful message that the copy and paste areas are not the same size. Sometimes the data lands but the formulas turn to errors. The good news is that Excel problems usually have Excel causes, which means a short list of fixes covers nearly all of them.
Before you blame the spreadsheet, do one quick test. Copy a line of text from your browser and paste it into Notepad or an email. If that works but Excel still will not cooperate, the fault is inside Excel and the steps below are for you. If copy and paste is broken everywhere, it is a system problem instead, and our general guide to copy and paste not working is the better starting point.
The most common Excel cause: merged cells
If you see “We can’t do that to a merged cell” or “The command you chose cannot be performed with multiple selections,” merged cells are almost certainly the reason. When you merge cells, Excel treats the whole block as a single cell. Copying a normal range and trying to drop it onto, or out of, merged cells creates a shape mismatch, and Excel refuses rather than guess what you meant.
To fix it, select the area, then on the Home tab click Merge & Center to unmerge. Do this for both the cells you are copying from and the cells you are pasting into. Then paste again. If you cannot unmerge because the layout has to stay, copy your data and use Paste Special with the Values option, which ignores the structural rules and just drops the contents in.
Paste Special is the fix for half of these problems
A lot of Excel paste trouble is not a failure to paste, it is pasting the wrong thing. 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.
When copy and paste does nothing at all
If Ctrl+C and Ctrl+V do nothing in Excel specifically, 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, and it can fill up or jam. On the Home tab, click the small arrow in the corner of the Clipboard group to open it, then click Clear All. Copy and try again.
2. Start Excel in safe mode to rule out add-ins
Add-ins are the single biggest cause of Excel-only copy and paste failures, because they can hook into the same actions you are using. Hold Ctrl while Excel opens and confirm you want safe mode, which loads 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 disable them, then re-enable one at a time to find the culprit.
3. Restart the program, then the machine
It sounds too simple, but a clean restart of Excel clears a surprising number of stuck states. If that does not do it, a full reboot clears the Windows clipboard process as well, which matters when the problem is not really Excel at all.
4. Restart the clipboard process (Windows)
When pasting is broken across Windows and not just Excel, the clipboard service itself can be stuck. The lightweight fix is to restart it. Open Task Manager, find Windows Explorer and restart it, which refreshes the desktop and the clipboard handling with it. If you work over Remote Desktop, the process to restart is rdpclip.exe, which handles clipboard sharing between your local machine and the remote session. End it in Task Manager, then relaunch it yourself with Win+R, typing rdpclip, since it does not come back on its own.
Other Excel-specific gotchas
- Filtered or hidden rows. Copying a filtered range can paste the hidden rows too, or refuse the paste. To copy only what you can see, select the range, press Alt+; to select visible cells only, then copy.
- Protected sheets. If the sheet or workbook is protected, paste is blocked on locked cells. Check the Review tab for Unprotect Sheet.
- 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 companion guides on Ctrl C and Ctrl V not working and copy and paste not working on Windows 11 cover those wider causes step by step. It is also worth checking what is actually on your clipboard using Windows clipboard history (Win+V), which tells you whether the copy even registered.
Most Excel paste problems come down to three things: merged cells changing the shape, an add-in interfering, or the wrong paste mode. Learn Paste Special, keep an eye on merged cells, and a quick safe-mode test will tell you the rest.