Microsoft Excel Cannot Paste the Data

What this does

Excel refuses a paste when the shape of the source and the shape of the target cannot be reconciled. In practice that means one of four things: merged cells on either side, a filtered or multi-area selection whose visible cells are not contiguous, a target range of a different size to the copied block, or a protected sheet. A stuck clipboard, usually caused by another application that monitors it, produces the same message with no shape problem at all. Before changing anything, confirm the symptom is reproducible — in another sheet, another file or after reopening — so you know whether the cause is local to this workbook. Treat “microsoft excel cannot paste the data” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected cells shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a workflow that saves repeating the same clicks every week into a method you can reuse, explain, and defend when the workbook leaves your screen.

A worked example

A header block with A1:C1 merged is copied over a table whose row 1 is not merged. The paste fails. Unmerge both (Home ▸ Merge & Center ▸ Unmerge Cells), paste, then re-apply the merge afterwards — or use Paste Special ▸ Values, which ignores the merge structure entirely. The message names nothing specific, so it gets read as file damage — while the fix is usually one merged header that took ten seconds to create. Work on a copy while you troubleshoot; a repair or cleanup step can change more of the file than the symptom suggests.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. The short version of “microsoft excel cannot paste the data”: identify the exact symptom, check the listed causes one at a time, and keep a copy of the file until the fix is confirmed.

Common mistakes

• Copying a multi-area selection made with Ctrl+click, which Excel can only paste into an identically shaped selection.
• Pasting into a filtered range and expecting values to skip the hidden rows — they do not.
• Ignoring sheet protection, which blocks the paste without naming protection as the cause.
• Restarting Excel repeatedly instead of testing Paste Special ▸ Values, which isolates a formatting or merge conflict in one step.

Frequently asked questions