Excel Can’t Paste Here: Fix the Copy Area Error

Errors & fixes · Updated November 19, 2026

Excel shows “You can’t paste here because the copy area and paste area aren’t the same size and shape” when the copied cells do not fit the selected destination, or when merged cells or separate selections make the paste incompatible. The quickest fix is to copy the intended range, click just one top-left destination cell, and paste; if that fails, check the shape of both ranges and whether either contains merged cells.

What the copy-area message means

When you copy cells, Excel treats them as a block with a particular number of rows and columns. A copied range of three rows by two columns has a different shape from a destination selection of two rows by three columns, even though both contain six cells. Excel may reject the paste because it cannot place the copied block into the selected area as requested.

The exact wording can vary with the action and Excel version. You may see a message about the copy area and paste area not being the same size and shape, or a related warning that an operation cannot be performed on multiple selections. These messages point to different details of the same general problem: Excel cannot map the copied cells cleanly onto the cells you selected.

This is usually a range-selection issue, not a sign that the workbook is damaged. The copied cells can still be on the clipboard, and you can normally resolve the problem without restarting Excel or rebuilding the data.

The quickest fix: paste into one cell

For a normal rectangular copy, Excel needs only the destination’s top-left cell. It expands the paste from there to cover the appropriate rows and columns. Selecting a large destination range in advance is a common cause of the size-and-shape warning, especially when that selection is not exactly the same dimensions as the copied range.

  1. Select the cells you want to copy and press Ctrl+C in Excel for Windows.
  2. Click the single cell where the copied range should begin. Do not drag over the expected destination block.
  3. Press Ctrl+V.
  4. If the warning remains, compare the source and destination shapes and check for merged cells or a noncontiguous selection.

For example, if you copy A2:C6, the source is five rows by three columns. Click one destination cell, such as E2, and paste; Excel can fill E2:G6. If instead you select E2:F7 first, the selected area is six rows by two columns, so it does not match the copied block. A single-cell starting point avoids that mismatch.

On a Mac, use Command+C and Command+V instead of Ctrl+C and Ctrl+V. The same selection principle applies. In Excel for the web, select one destination cell and use the Home tab’s Paste command or the available keyboard shortcut; browser and operating-system shortcut behavior can vary.

Check the dimensions and direction

If you need to select a destination range before pasting, make its dimensions match the copied range. Count rows and columns separately, and remember that shape includes direction: a 2-by-5 block is not interchangeable with a 5-by-2 block. The upper-left destination cell must also be the correct starting point; Excel will not rotate or transpose the cells automatically during an ordinary paste.

Be careful when selecting with the mouse. It is easy to include an extra row or column, particularly when the copied range is near a worksheet edge or when row and column headings are hidden. The Name Box to the left of the formula bar can help you identify or select a range: after copying, enter a destination reference such as E2 in the Name Box and press Enter, then paste.

If your goal is to turn rows into columns, use a transpose operation rather than trying to make mismatched ranges fit. Copy the source, select one destination cell, and choose Home > Paste > Transpose if that command is available in the paste options. Transposing changes the orientation; it does not solve unrelated issues such as merged cells or protected destinations.

Look for merged cells

Merged cells are a frequent cause of paste errors because a merged area behaves differently from a normal grid of individual cells. For instance, a copied block may contain ordinary cells while the destination overlaps a merged cell that spans several columns. Excel cannot always match those different layouts, even when the visible areas seem similarly sized.

Inspect both the copied range and the destination for merged cells. Select a suspicious cell and check Home > Merge & Center. If the command indicates that cells are merged, you can use Home > Merge & Center > Unmerge Cells to return them to individual cells. Unmerging keeps the value in the upper-left cell of the former merged area; it does not distribute that value across all the cells. Consider whether the layout should be preserved before changing it.

If the destination’s merged layout is intentional, arrange the source to have a compatible layout or paste the contents in smaller pieces into suitable cells. Pasting values only may help when formatting is the obstacle, but it will not make incompatible merged-cell structures equivalent.

Filtered lists and multiple selections

A filtered table or list can make a range look like one continuous block even when the visible rows are separated by hidden rows. Similarly, holding Ctrl while selecting several areas creates a noncontiguous selection. These selections are not always valid as a single paste destination. Excel may report that the operation cannot be done on multiple selections, or it may refuse a paste because the selected cells do not form one compatible rectangle.

For a straightforward paste, clear the filter temporarily if that is appropriate, select one continuous destination range, and paste. Clearing a filter changes what is displayed, not the underlying rows, but check that the result will not overwrite records you meant to leave alone. If you need to work only with visible cells, use Home > Find & Select > Go To Special > Visible cells only where that option is available, then verify the selected cells before copying or pasting. Excel’s shortcuts and selection behavior can differ on Mac, so use the menu command if a Windows shortcut does not apply.

Do not assume that copying visible rows guarantees a safe paste into another filtered list. Hidden rows, different filter results, and separated visible areas can make the source and destination layouts unequal. For important data, paste into a temporary unfiltered area first, check the row order and contents, and then transfer the verified results.

Tables, protected sheets, and paste options

Excel tables add structure to a worksheet: they have defined columns, headers, and often calculated columns that fill formulas down automatically. A paste that crosses a table boundary or covers a different set of table columns may behave differently from a paste into an ordinary range. Try pasting into the first intended table cell, and confirm that the copied columns line up with the table columns. If you are copying only part of a row, make sure the destination selection does not include an incompatible number of columns.

A protected worksheet can also prevent changes to locked cells. That is distinct from a range-size mismatch, but it can appear during the same attempt to paste. If Excel reports that the sheet is protected or the cells are locked, ask the workbook owner or use Review > Unprotect Sheet if you are authorized and have the required password. Do not remove protection if it is there to preserve controls or important formulas.

Paste Special can be useful when the problem is formatting rather than the cell layout. After copying, use Home > Paste > Paste Special to choose options such as Values or Formulas, when appropriate. These options affect what is pasted; they do not let an incompatible multi-cell selection ignore its shape. If the ordinary paste is rejected, first correct the destination and merged-cell layout, then choose a suitable paste option.

A reliable troubleshooting sequence

Work through these checks in order rather than repeatedly retrying the same paste. This helps distinguish a simple selection mistake from a layout or protection issue:

  • Press Esc once if Excel is still showing a selection or paste operation you no longer want, then copy the source range again.
  • Confirm that the source is one rectangular range. If you selected separate areas with Ctrl-click, copy and paste each area individually or combine the data in a temporary rectangular range.
  • Click one destination cell instead of selecting a block, then try the paste.
  • If you must select a block, count its rows and columns and match them to the source exactly.
  • Check for merged cells in both ranges, and decide whether to unmerge or use a compatible layout.
  • Check whether a filter, hidden rows, or a table boundary has made the selected area different from what it appears to be.
  • Read the full warning. A protection message, a message about multiple selections, and a size-and-shape message require different fixes.

If the error happens in only one workbook, try copying a small range into a blank area of a new workbook. If that works, the original destination’s layout, protection, or selection is likely involved. If the problem occurs across workbooks, close and reopen Excel after saving your work, and check whether another application or remote session is affecting clipboard use. These steps are for diagnosis; they do not imply that the workbook itself is corrupt.

When to use another method

Sometimes the data is not arranged in a way that ordinary copy-and-paste can handle safely. If you are moving a few values into a differently shaped area, paste one cell or one matching block at a time. If you are changing row and column orientation, use Transpose. If you want only displayed results rather than formulas and formatting, choose Paste Values. For repeated transfers between structured lists, Power Query or an appropriately designed lookup may be more reliable than manually pasting misaligned ranges, although those tools involve their own setup and should be chosen for the task.

Copying and pasting into a temporary blank worksheet is a useful alternative when you are unsure which cells will be affected. It gives you room to inspect the result before replacing or updating the original data. For a move rather than a copy, avoid deleting the source until you have confirmed that the destination contains the intended information. Keep a separate copy of important workbooks before making broad changes.

Frequently Asked Questions

Why does Excel say the copy area and paste area are not the same size?
Usually, you selected a destination block whose row and column counts do not match the copied block. Click one destination cell and paste, or select a destination range with the same dimensions as the source.

Can I paste a range into a different-sized selection?
For a multi-cell source, select a single destination cell for Excel to place the block from its top-left corner, or select an exactly matching range. A different-sized preselected block can trigger the warning. A one-cell source is a separate case and may fill a selected range.

Do merged cells cause this Excel error?
Yes. A merged source or destination can make the cell layouts incompatible even if the visible areas look similar. Check Home > Merge & Center, and unmerge only if changing the layout is acceptable.

Why can’t I paste into filtered rows?
A filtered range may contain hidden rows or multiple separated visible areas, so it is not necessarily one continuous destination. Try a continuous range or work with visible cells deliberately, then verify which records the paste affects.

Will Paste Special fix a size mismatch?
Not by itself. Paste Special changes whether Excel pastes values, formulas, formatting, or other supported content. First make the source and destination layout compatible; then choose the paste option that matches your goal.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.