Excel You Can’t Paste This Here: Causes and Fixes Explained

Excel You Can't Paste This Here: Causes and Fixes Explained

Excel’s “You can’t paste this here” message usually means the destination does not match the copied cells or cannot accept them—for example, because of merged cells, a filtered range, or worksheet protection. First, press Esc, copy the source again, click just one destination cell, and paste; if that fails, check the range shape, merged cells, filters, and protection.

What the message means

The wording can vary by Excel version and situation. You may see a short “You can’t paste this here” warning or a longer message explaining that the copy area and paste area differ in size or shape. The message is about Excel’s ability to place the copied content in the selected destination; it does not, by itself, mean that the copied data is corrupt.

Excel copies more than the values you see in cells. A copied range can include formulas, formatting, borders, data validation, and other cell properties. The shape of the selection matters too: a range of three rows and two columns has a different shape from a range of two rows and three columns, even though both contain six cells. Excel may reject a paste when the destination selection, layout, or restrictions conflict with what is on the clipboard.

Before trying fixes, note whether you copied from Excel or another program, whether the destination is in the same workbook, and whether the sheet has filters, merged cells, or protection. Those details help narrow down the cause without risking an unintended overwrite.

Try these quick fixes first

On Windows, press Esc once to clear the current copy selection, then select and copy the source again with Ctrl+C. Click the upper-left destination cell—not a larger preselected block—and press Ctrl+V. On a Mac, use Command+C and Command+V; Esc also cancels the active copy selection. Pasting a rectangular range into one starting cell is normally the simplest way to let Excel determine the destination size.

Check the selection: Make sure the source is one continuous rectangular range, not several separately selected areas.
Choose a simple destination: Try an empty area on an unfiltered, unprotected sheet in the same workbook.
Try values only: If you only need the displayed results, use Home > Paste > Values. This avoids carrying over much of the source formatting.
Copy again: A new copy operation can replace a stale clipboard selection, especially after switching between applications.

If the paste works in a blank area but not in the original location, the problem is likely a feature or restriction of that destination rather than the source data. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac if a paste succeeds but changes cells you did not intend to change.

Match the copied and destination ranges

A frequent cause is selecting a destination block that does not match the copied block. For example, copying A2:B6 gives a five-row-by-two-column range. If you then select a destination area with four rows and two columns before pasting, Excel may report a size or shape mismatch. Select only the destination’s top-left cell, or select a destination block with the same dimensions.

For a one-cell copy, selecting one destination cell is straightforward. For a multi-cell copy, a single destination cell usually acts as the starting point and Excel fills the neighboring cells with the copied block. If you deliberately select a destination range, make its row and column counts match the source. Also check that the copied range is contiguous: holding Ctrl while selecting separate areas can create a noncontiguous selection that cannot be pasted as one ordinary block.

Watch for accidental extra cells in the source selection. A copied range that includes a blank row or column still has that larger shape. If you are unsure, click a single cell outside the current selection, select the exact intended range again, and copy it.

Check for merged cells

Merged cells are a common source of confusing paste failures. A merged area behaves as one cell for many editing operations, although it covers multiple rows or columns. Pasting a normal rectangular range into a destination that contains merged cells—or pasting a merged source into a differently arranged area—can create incompatible shapes.

Inspect both the source and destination for merged cells. On the Home tab, check the Merge & Center control in the Alignment group; the control may display that merging is active for the selected area. If the destination does not need merged formatting, select the affected cells and choose Home > Merge & Center > Unmerge Cells. This changes the layout, so confirm that unmerging is acceptable before doing it, particularly in a shared report or template. Then try the paste again.

If the merged appearance is important, keep the paste within a destination that has the same merged-cell arrangement as the source. Pasting values only does not necessarily solve a structural conflict caused by mismatched merged cells.

Consider filters and hidden rows

Filtered lists can make a range look like one continuous block while some rows are hidden. Copying only visible cells and pasting into a destination that includes hidden rows can produce a mismatch or put data in unexpected records. This is especially important when working with a filtered table: the visible rows on screen may not represent every row in the underlying range.

For a safe test, clear the filter temporarily, if appropriate, and paste into a clearly identified, unfiltered range. If you must work only with visible rows, make sure the copied and destination cells correspond in the same order and that the destination does not include hidden rows you intend to leave untouched. Do not assume that selecting a visible block means Excel will paste only into the visible destination cells.

When the filtered data is important, consider copying the visible results to a separate worksheet first, checking the rows, and then pasting from that clean range. This extra step helps prevent overwriting records that are hidden by the current filter.

Check worksheet protection and permissions

A protected worksheet can prevent changes to locked cells. If the paste destination is locked, Excel may refuse the paste even when the range sizes are correct. Look for protection controls on the Review tab. If you are authorized to edit the sheet, choose Review > Unprotect Sheet and enter the password if Excel requests it. Protection may have been applied intentionally, so do not remove it without checking with the workbook owner.

Some protected sheets allow edits in designated unlocked cells while blocking other areas. In that case, paste into an allowed input area or ask the owner to adjust the sheet’s permissions. Workbook structure protection is different from worksheet protection: it restricts actions such as adding, moving, or deleting sheets, rather than generally controlling edits to cell contents.

In a shared or read-only file, also confirm that you have editing access. A file opened in a restricted mode may limit changes independently of the paste selection. If you can edit other cells but not this destination, the sheet’s protection or cell-level restrictions are more likely than a general clipboard problem.

Tables, formatting, and content from other apps

Excel tables are designed to accept data, so being inside a table does not automatically make pasting impossible. However, the table’s headers, totals row, calculated columns, or surrounding layout can affect what a particular selection will accept. Test in the intended data area rather than over headers or totals. If the content is important, paste into a temporary worksheet first to check how Excel interprets it.

When copying from a web page, email, or another spreadsheet program, the clipboard may contain formatting or content that does not translate cleanly. Use Home > Paste > Values when you need plain cell results, or use the Paste Special options that suit the content. For a plain-text source, pasting into a blank worksheet area can help distinguish a source-format problem from a destination restriction. Avoid assuming that “Values” will resolve every error: it changes what is pasted, but it cannot make a protected or structurally incompatible destination available.

Excel for the web may also depend on browser clipboard permissions and can behave differently from the Windows desktop app when copying between browser tabs or applications. If a paste fails only in the browser, try the workbook in the desktop app if you have access, or use Excel’s in-app copy and paste commands. On Mac, the ribbon options are similar, but keyboard shortcuts use Command in place of Ctrl for common copy, paste, and undo actions.

A reliable troubleshooting sequence

Use this sequence to identify the cause without changing the workbook more than necessary:

Press Esc, then copy the exact source cells again.
Click a single empty destination cell and paste. Do not preselect a differently sized block.
If it fails, test the same copy in a blank area on a new worksheet. If that works, inspect the original destination for merged cells, filters, protection, or table layout.
If it still fails, copy a small sample of the source and try Home > Paste > Values in the blank area.
Check whether the source is a single rectangular range and whether the workbook is editable.
When you identify the restriction, make only the necessary change, then verify the pasted rows and columns before saving.

This process separates three questions: is the source selection valid, can Excel read the clipboard content, and is the destination allowed to accept it? A successful test in a blank worksheet is particularly useful because it points toward a destination-specific issue. If even a small sample cannot be pasted into a blank sheet, restart Excel and reopen the workbook; if the problem continues, check whether another application or a clipboard-management tool is interfering.

Frequently Asked Questions

Why does Excel say the copy area and paste area are not the same size?
A selected destination range may have a different number of rows or columns from the copied range. Click one destination cell to paste the full block, or select a destination block with the same dimensions.

Can I paste a range into one cell?
Yes. For a normal rectangular range, clicking one starting cell and pasting usually places the copied block beginning there. Check that the surrounding cells can be overwritten before you paste.

Will Paste Values fix “You can’t paste this here”?
It can help when formatting or content from another application is the issue. It will not, by itself, fix a protected destination, mismatched merged cells, or an unsuitable selection.

Why can I paste into a blank sheet but not into my table?
The original destination may have protection, merged cells, filters, or a table layout that conflicts with the selection. Check those features and test in the table’s data rows rather than over its headers or totals.

How do I paste into a protected Excel sheet?
If you have permission, use Review > Unprotect Sheet and provide the password if prompted, then paste into the intended cells. Otherwise, ask the workbook owner to unlock the destination or provide an approved input area.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.