Excel Copy and Paste Not Same Size? Fix the Error

Excel displays the copy-and-paste size error when the copied cells and the selected destination do not have a compatible shape. The quickest fix is usually to select only the destination’s top-left cell and paste; if you select a whole destination range, make it the same number of rows and columns as the copied range.

What the error means

The message is Excel’s way of saying it cannot map the copied cells neatly onto the cells you selected. For example, copying a block that is 3 rows tall and 2 columns wide gives Excel six cells arranged in a specific shape. A selected destination that is 2 rows tall and 3 columns wide also contains six cells, but its shape differs, so Excel may reject the paste. Matching the cell count alone is not always enough.

The exact wording varies by Excel version and by the operation. You may see a message explaining that the copy area and paste area are not the same size, or that the areas do not have the same shape. In either case, Excel is generally reporting a range-selection mismatch, not a damaged workbook or a problem with the data itself.

There is an important exception: if you copy a single cell, Excel can usually paste it into a larger selected range, filling the selection with that cell’s content. For a copied range containing multiple cells, select a destination with the matching shape or select just its upper-left cell and let Excel place the copied block from there.

How Excel matches copied and destination ranges

Excel treats a copied rectangular range as a grid. If you copy A1:B3, the copied area has 3 rows and 2 columns. Selecting D1:E3 as the destination gives Excel the same 3-by-2 shape. Selecting D1:F2 gives it a 2-by-3 shape, which is different even though both ranges contain six cells.

When you click one destination cell, Excel uses that cell as the starting point and expands the paste to fit the copied grid. If the copied area is A1:B3 and you click D1, the result occupies D1:E3. This is often the most reliable method because it avoids accidentally including an extra row or column in the destination selection.

Copying non-adjacent cells or ranges can complicate the match. A selection made with Ctrl may consist of separate areas rather than one continuous rectangle. Some multi-area selections cannot be pasted as a normal block, especially when the destination is a different arrangement of separate cells. If you are unsure, copy one continuous range at a time.

The quickest way to fix the error

Press Esc to clear an unintended selection or cancel the current copy outline, then select the source cells again.
Check the source range’s boundaries. Confirm that you have not included an extra blank row, column, heading, or total.
Copy the range with Ctrl+C in Windows Excel, or Command+C on a Mac.
Click only the top-left cell where the pasted block should begin, then paste with Ctrl+V in Windows or Command+V on a Mac.
If you need to select the full destination first, make sure it has the same row-and-column dimensions as the source.

For example, suppose you want to copy A2:C6 into F2:H6. Those ranges are both five rows by three columns, so selecting F2 and pasting is straightforward. If you accidentally select F2:H7, the destination has an extra row. Click F2 alone and paste, or correct the selection to F2:H6.

If you are copying a single value and want to fill many cells with it, select the destination range before pasting. That is a different case from pasting a multi-cell block. To repeat a value or formula through a selected range, you can also type it and use Ctrl+Enter on Windows; on Mac, use Control+Return. Check the result before continuing, particularly if the selected cells contain existing data.

Common causes beyond a simple size mismatch

An extra row or column: The source includes a total row, blank cell, or heading that the destination does not include, or vice versa.
Reversed dimensions: The source is three rows by two columns, while the destination is two rows by three columns. Equal cell counts do not make the shapes interchangeable.
Merged cells: A merged area behaves differently from a grid of ordinary cells. Copying into a destination with a different merged-cell layout can prevent a paste or produce a related warning.
Separate selected areas: Ctrl-clicking cells creates a non-contiguous selection. Excel may not be able to place a rectangular copied range into that pattern.
A selection that includes hidden or filtered rows: The visible cells may not form the simple continuous destination you expect.
Copying whole rows or columns: A full-row or full-column copy is much larger than a small destination range. Paste from the corresponding row or column, or copy only the cells you need.

Merged cells are a frequent source of confusion because their appearance can conceal the underlying grid. If the source or destination contains merged cells, inspect the layout before changing it. On the Home tab, the Merge & Center control can show whether the selected area uses merging. Unmerging cells may help, but it changes the sheet’s layout; do not do it casually in a formatted report or shared template.

Copying into filtered or hidden rows

A filtered list can make a destination look like a simple sequence while rows between the visible records are hidden. A normal selection may still include those hidden rows. Pasting a multi-cell block into such a selection can fail, or the result may not line up with the visible records as intended.

First decide whether the paste should affect every row in the range or only the rows currently visible after filtering. If every row should be updated, clear or adjust the filter, paste into the continuous range, and restore the filter afterward. If only visible cells should be changed, use Go To Special to select visible cells only: on Windows, press F5, choose Special, select Visible cells only, and choose OK. Then proceed carefully, because the selected cells may form separate areas rather than one continuous block.

Do not assume that selecting visible cells turns a filtered range into a normal rectangular destination. If Excel rejects the paste, a safer approach is to apply the update in a helper column or work with a small, unfiltered copy of the relevant records. This also makes it easier to verify that hidden records were not changed by accident.

When the source and destination should differ

Sometimes a different destination size is intentional. If you are trying to repeat a small block, copy it and paste from the destination’s top-left cell; Excel may repeat the pattern when the selected destination is compatible. If the repeat does not work as expected, paste into one matching block first, then copy that larger block to the next location.

If the goal is to put a horizontal range into a vertical range, ordinary paste is not the right operation because it does not rotate the grid. Copy the source, right-click the destination’s top-left cell, choose Paste Special, and select Transpose. This swaps rows and columns. For example, a one-row range containing four cells becomes a four-row, one-column range. The destination should still provide enough space for the transposed result.

If you only need to move a value, formula, or format rather than the whole block, use a more specific paste option. On the Home tab, open the Paste menu and choose an appropriate option such as Values or Formulas. Paste Special can reduce unwanted changes, but it does not make incompatible range shapes compatible. The cells still need to accept the size and arrangement of the operation.

Check formulas, formatting, and existing data

A successful paste can still produce an unwanted result. Standard paste can bring over formulas, formatting, number formats, comments or notes, and other cell properties, depending on what was copied. A formula may also adjust its relative references when pasted elsewhere. If you intended to copy displayed results only, use the Values paste option instead of assuming that regular paste will preserve only the visible numbers.

Before pasting over a populated destination, check whether existing cells will be replaced. For a large update, save the workbook or make a separate copy first. After pasting, inspect the first and last rows and columns, and verify a few formulas or values in the middle. This is especially useful when working with filtered lists, merged cells, or ranges that include totals.

If the paste still fails after the dimensions match, try copying a smaller continuous range into a blank area of the same worksheet. If that works, the issue is likely tied to the original destination’s layout, such as merged cells, hidden rows, protection, or a multi-area selection. If it fails there too, recopy the source and check whether the selection includes objects or entire rows and columns rather than the intended cells.

Differences on Mac and Excel for the web

The range-matching principle is the same in Excel for Microsoft 365 on Windows, Excel for Mac, and Excel for the web: a multi-cell copied range needs a compatible destination shape. The common copy and paste shortcuts differ by platform. Use Ctrl+C and Ctrl+V on Windows; use Command+C and Command+V on Mac. In Excel for the web, browser and operating-system shortcuts can sometimes be intercepted by the browser, so the ribbon’s Copy and Paste commands are an alternative.

Some dialog labels and keyboard shortcuts vary between the desktop versions and the web app. If you cannot find Go To Special or a particular Paste Special choice in Excel for the web, open the workbook in the desktop app and use the corresponding command there. Mac users can also use the ribbon or context menu rather than relying on a Windows-only shortcut. The destination-size rule itself does not change.

Frequently Asked Questions

Why does Excel say the copy area and paste area are not the same size?
Excel sees a difference between the copied range and the selected destination, such as a different number of rows or columns, a different shape, or a layout affected by merged or separate cells. Select only the destination’s top-left cell or make the full destination match the source.

Can I paste a range into a larger range in Excel?
For a multi-cell source, click the destination’s top-left cell and paste; Excel places the copied block beginning there. A single copied cell can generally be pasted into a larger selected range to fill it. If you select a larger range for a multi-cell source, the dimensions and arrangement must be compatible.

Why does paste fail even though both ranges have the same number of cells?
Their shapes may differ. A 2-by-3 range and a 3-by-2 range each contain six cells, but their row and column arrangements are not the same. Merged cells and non-contiguous selections can also cause a mismatch.

How do I paste only into visible cells after filtering?
On Windows desktop Excel, select the target range, press F5, choose Special, select Visible cells only, and choose OK. Then paste carefully; visible cells can form separate areas, so a multi-cell paste may still be rejected. If so, update the records with the filter cleared or use a helper range.

How do I switch rows and columns while pasting?
Copy the source, choose the destination’s top-left cell, open Paste Special, and select Transpose. The pasted result swaps rows and columns, so make sure the destination has enough rows and columns for the new orientation.

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.