Do All Merged Cells Need to Be the Same Size in Excel?

No. In Excel, merged cells do not all have to be the same size: one merged area can cover two columns while another covers three, for example. However, some operations—especially copying, pasting, or sorting ranges that contain merged cells—can fail when the merged areas have different layouts.

What “same size” means in Excel

The phrase can refer to two different things: the physical dimensions of cells, or the shape of the merged ranges. Excel sets column width for an entire column and row height for an entire row; individual cells do not have their own independent width or height. A merged area takes up the combined space of the rows and columns it covers.

For example, merging A1:B1 creates a one-row area spanning two columns. Merging D1:F1 creates another one-row area spanning three columns. Those areas have different widths, but Excel allows both on the same worksheet. Likewise, a merge spanning two rows can be a different height from one spanning three rows, particularly if the rows have different heights.

Shape is a separate question. A merge across A1:B1 is two columns by one row; a merge across A2:A3 is one column by two rows. Both are valid, but they are not the same layout. Some Excel actions can handle one merged range at a time yet reject a larger selection containing a mixture of shapes.

How merged ranges work

When you merge a rectangular selection, Excel turns that selection into one larger cell for purposes such as displaying text and applying alignment. The underlying worksheet still has its rows and columns, but the individual cells within that rectangle are no longer separately available for normal entry while they are merged.

In Excel for Microsoft 365 on Windows, select the cells and choose Home > Merge & Center. Use the dropdown beside the button to choose an option such as Merge Cells or Merge Across. Merge Across makes separate merged areas for each row in the selection, rather than creating one tall merged area. On Mac, the merge controls are also on the Home tab; the exact ribbon layout can vary slightly by window size.

Excel keeps the value in the upper-left cell of a selection when you merge it. If other selected cells contain data, Excel warns that merging keeps only the upper-left value and discards the other contents. Check the cells first, and move or combine any information you need to retain before confirming. Merging is not a way to combine several cell values into one.

When matching layouts matter

Different-sized merged areas are fine when they are simply part of a worksheet’s layout. The difficulty comes when Excel must treat a selection of cells as a consistent grid. A range with one merge covering two columns and another covering three does not have the same cell structure from one section to the next. Copying or pasting that range into another grid can leave Excel unsure how to map the merged areas.

This is why a user may see a message such as “To do this, all the merged cells need to be the same size.” It does not mean every merged range in the entire workbook must match. It refers to the merged cells involved in the operation or selection. The exact restriction depends on the action and the arrangement of the selected cells.

Sorting and filtering are frequent sources of trouble. A merged cell can span multiple records or columns, so Excel cannot always move or filter the affected rows as independent records. Even if the merged areas look uniform, sorting a range that contains merges may be blocked or produce an unsuitable layout. Matching dimensions are not a guarantee that every operation will work.

Similar limitations can appear when you paste into or across a range containing merges, insert or delete cells within a merged area, or try to apply a command to a selection that only partly overlaps a merge. The key issue is usually the structure of the selected range, not whether all merges elsewhere on the worksheet have identical dimensions.

Why Excel reports a merge-size error

Excel’s worksheet commands generally work best with regular rows and columns: each row represents a record, and each column represents one field. Merged cells disrupt that regular structure by making a rectangle behave like one cell for some purposes while occupying several grid positions. A selection containing different merge shapes is even harder to interpret consistently.

For instance, imagine a report where A1:B1 is merged for one heading and A2:C2 is merged for another. If you select both rows and try to copy them into a destination with a different arrangement, there is no simple one-to-one mapping between the source and destination cells. Excel may stop the action rather than guess where the contents or formatting should go.

It also helps to distinguish a merge-size error from a problem caused by protected cells, a partly selected merge, or a destination that already contains merges. If an action fails, look at both the selected range and the destination. A selection can include a merged area even when its outline is not obvious, and selecting only part of a merged area can prevent some commands from working.

How to resolve the error

First decide whether the merge is necessary for the task. If it is only decorative, removing the merges is usually the most reliable fix, especially before sorting, filtering, copying tables, or inserting cells. In Excel for Microsoft 365 on Windows, select the affected range and choose Home > Merge & Center > Unmerge Cells. The Mac ribbon has the equivalent merge controls on Home.

Inspect the selection. Identify every merged area that intersects the cells you are trying to change. Check the destination as well if you are pasting.
Preserve the contents. Before unmerging, note that the value remains in the upper-left cell. If other visible text needs to be retained, copy or combine it elsewhere first.
Unmerge the affected cells. Select the relevant area and choose Unmerge Cells. This restores the cells in the grid, though the former merged area’s content stays in its upper-left cell.
Perform the operation. Copy, paste, sort, filter, or edit the now-regular range. Confirm that the selection covers the full table where appropriate.
Reapply presentation formatting only if useful. If you merge again, keep the ranges consistent in the section where you expect to copy or sort them, and avoid merging across separate records.

If you need to keep merges, try the operation on one compatible block at a time rather than selecting several sections with different merge patterns. For a paste, make the destination’s merged layout match the source layout exactly, or paste only the values or formatting that you need using the available Paste options. If the task involves data management rather than appearance, unmerging is generally safer than trying to make a complicated selection fit.

Alternatives that preserve a regular grid

For a heading that should look centered over several columns, consider Center Across Selection instead of Merge & Center. It centers the text visually across a selected horizontal span without combining the cells. In Windows Excel, open the Format Cells dialog from the Alignment group’s dialog launcher, choose the Alignment tab, and set Horizontal to Center Across Selection. This keeps the cells separate, which is more compatible with sorting, filtering, and table-like layouts. The Format Cells dialog on Mac also provides alignment settings, though its route and appearance can differ.

Another option is to place a title in one cell and adjust column widths, alignment, and wrapping so it displays well without a merge. For text that needs to occupy several lines within one cell, use Wrap Text rather than merging rows. For section labels in a report, use formatting such as bold text, fill color, borders, or indentation to create visual grouping while leaving the underlying grid intact.

These alternatives are not identical to a merge. Center Across Selection does not create one large editable cell, and a title may not be centered as expected if adjacent cells contain values. Still, keeping each data item in its own cell is usually better for a worksheet that people need to analyze or maintain.

Good practices for worksheets with merged cells

Merges are most suitable for presentation areas such as a report title or a heading above a static block. They are less suitable inside a list of records, where each row should remain independently sortable and filterable. A worksheet can contain merges of different sizes, but designing them carefully helps avoid errors later.

Keep merged headings out of the body of a sortable or filterable data table.
Use a consistent merge pattern within a block that you expect to copy or format as a unit.
Check for existing values before merging, because Excel retains only the upper-left cell’s contents.
Before sorting or inserting cells, consider unmerging the affected range and restoring visual formatting afterward.
If a workbook is shared, explain which areas are presentation-only and which areas contain editable data.

For a simple title across columns A through D, merging A1:D1 may be practical. For a table underneath it, keep each column heading and each record in separate cells. That gives the title the desired appearance without making the data beneath it harder to sort, filter, copy, or extend.

Frequently Asked Questions

Can I have merged cells of different sizes on one worksheet?
Yes. Excel allows merged areas with different widths and heights in different parts of a worksheet. Problems arise only when a particular selection or operation cannot work with the mix of layouts.

Do merged cells need to be the same size to copy and paste?
Not in every situation, but different merge patterns in the source or destination can prevent a paste. For dependable copying, use matching layouts or unmerge the affected range before copying.

Can I sort a range that contains merged cells?
Sorting can be restricted or behave poorly when merges intersect the range. Unmerge the cells before sorting, and keep each record in its own row if the data needs to be sorted regularly.

What happens to data in the other cells when I merge?
Excel retains the upper-left cell’s value and warns that contents in the other selected cells will be discarded. Preserve any information you need before confirming the merge.

Does unmerging restore the original values?
No. Unmerging restores the individual cells, but it does not bring back values discarded during the merge. The retained value remains in the upper-left cell of the former merged 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.