Some links on this page are affiliate links: if you buy through them we may earn a commission, at no extra cost to you.
Excel displays “This operation requires the merged cells to be identically sized” when the range you selected contains merged areas with different dimensions, or combines merged and ordinary cells. A merged area that covers two rows by three columns cannot be processed in the same rectangular operation as one covering a single row by three columns. The reliable fixes are to unmerge the affected range or resize every merged block in that operation so each occupies the same number of rows and columns. Save a copy first, locate every merge, check the complete range used by the command, then retry the operation.
What does “all the merged cells need to be the same size” mean?
Excel treats a merged area as one larger cell made from two or more ordinary cells. Internally, however, the worksheet still has a grid of rows and columns. Commands such as sorting need a regular rectangular grid, so Excel checks that each merged area crossing the selected range has identical dimensions.
As an Amazon Associate I earn from qualifying purchases.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →The error appears when any of these conditions is true:
- The selected range contains both merged and unmerged cells.
- Two merged areas cover different numbers of rows.
- Two merged areas cover different numbers of columns.
- Your selection cuts through only part of a merged block instead of including the whole block.
Microsoft’s troubleshooting wording is exact: “This operation requires the merged cells to be identically sized.” Although sorting is the most familiar trigger, the same structural conflict can affect other commands that require a consistent rectangular range.
Popular on Amazon
- Read Before You Buy — No Video Output: These adapters support charging and USB 2.0 data transfer, but cannot transmit video signals. Except for standard USB webcams (which use USB data only), they are not compatible with HDMI/DisplayPort cables, video-capable USB-C hubs, or docking stations with video output.
- Convert USB-A Ports to USB-C: Designed to connect USB-C earphones, cables, flash drives, card readers, and other USB-C accessories to standard USB-A ports. Plug-and-play with no drivers or software required.
- Aluminum Alloy Housing: Built with a sturdy aluminum alloy shell that aids in heat dissipation and protects against daily wear and scratches. Designed to maintain a stable and secure connection.
- Compact & Travel-Friendly: The ultra-compact design allows the adapter to stay plugged into your device without blocking adjacent ports or adding bulk, reducing wear and tear on your original USB ports.
- 12-Month Warranty: Backed by a 12-month manufacturer warranty for peace of mind. Designed to meet strict quality control standards for reliable everyday performance.
Why does Excel block sorting when cells are merged?
Sorting moves complete records through rows. A merged heading or label interrupts that one-row-per-record structure, and differently sized merges give Excel no unambiguous way to move the affected cells together. Microsoft identifies two common layouts behind the warning: some cells in the sort range are merged while others are not, or all the merged areas exist but have different sizes.
For example, suppose a worksheet has one label merged across columns A:C and another label merged across A:D. Selecting both labels and the rows beneath them creates a range with incompatible widths. A different problem occurs when a title is merged across A:C but the data rows below are ordinary cells; including the title in a sort selection mixes a merged block with unmerged cells.
A selection that starts inside a merge is also invalid for many operations. Excel must receive the complete merged area, not a partial slice of it. Selecting the full rectangular region again can reveal that the apparent error was caused by the selection boundary rather than by the entire worksheet.
How does merging affect the contents of a worksheet?
When Excel merges cells in a left-to-right worksheet, the upper-left cell supplies the visible content. Any content in the other cells of the selected area is deleted as part of the merge. This matters when deciding whether to unmerge: the operation changes layout, but the original merge may already have discarded text or formulas from the non-upper-left cells.
Before changing a report or template, save a separate copy. After unmerging, inspect labels, formulas, borders, alignment and row heights; a heading that looked centered in one large cell may need a new alignment or a different layout once it becomes several ordinary cells.
Also popular on Amazon
- 5-in-1 USB-C Hub: Experience comprehensive connectivity featuring a Power Delivery input, two USB-A 2.0 ports, a USB-A 3.0 port, and an HDMI port. (Note: The USB-C power delivery input port is only for connecting an external wall charger to power your laptop and cannot power peripheral devices.)
- 90W Pass-Through Charging: Achieve optimal charging with 90W pass-through power to your laptop, supported by a total input of 100W, with the hub reserving 10W for operational efficiency. (Note: Wall charger not included.)
- Quick Data Transfers: Accelerate your productivity with rapid data transfers using a high-speed 5Gbps USB 3.0 port and two 480Mbps USB 2.0 ports.
- 4K HDMI Display: Enhance your visual experience with a hub capable of delivering 4K resolution at 30Hz in both mirror and extend modes. Please note that this hub is compatible with MacBook (macOS 12 and newer), Windows 10 and 11, ChromeOS, and laptops equipped with DP Alt Mode and Power Delivery. Note: This device is not compatible with Linux.
- What You Get: Anker USB-C Hub (5-in-1, 4K HDMI), welcome guide, 18-month warranty, and our friendly customer service.
How can I find every merged cell in the workbook?
Use Excel’s format search rather than checking cells one by one. The desktop interface can list all cells that use the Merge cells format.
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Fix the driver behind crashes, sound loss and screen glitches3Repair Windows errors before they cause bigger problems- Save a copy of the workbook.
- On the Home tab, choose Find & Select > Find.
- In the Find and Replace window, select Format.
- Open the Alignment tab.
- Select Merge cells, then confirm the format choice.
- Choose Find All.
- Review the results list. Clicking a result selects the corresponding merged area on the sheet.
The results show where merges exist; they do not by themselves identify which merge conflicts with your command. Compare the listed areas with the exact range you are trying to sort, filter, copy, insert or format.
What should I check before repairing the error?
First identify the command that failed and its full input range. Then check the following points:
- Complete boundaries: Does the selection include every row and column of each merged area, or does it stop in the middle of one?
- Dimension consistency: Do all merged blocks in that range span the same number of rows and the same number of columns?
- Unmerged cells: Are ordinary cells mixed with merged blocks in the same rectangular selection?
- Layout role: Is a merge merely a decorative title, or does it contain a heading, formula or label that must remain visually grouped?
- Scope: Are you accidentally including a page title or section banner when the operation should apply only to the data rows?
These checks distinguish a bad selection from a workbook design that genuinely needs repair. If the operation is a data sort, exclude decorative headings and select only the consistently structured records. If the heading must be included, use one of the repair choices below.
How do I fix the error by unmerging cells?
Unmerging is the standard repair when the range is data that must be sorted or filtered. It removes the merge setting from the selected area and restores individual grid cells.
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallAlso popular on Amazon
- Sleek 7-in-1 USB-C Hub: Features an HDMI port, two USB-A 3.0 ports, and a USB-C data port, each providing 5Gbps transfer speeds. It also includes a USB-C PD input port for charging up to 100W and dual SD and TF card slots, all in a compact design.
- Flawless 4K@60Hz Video with HDMI: Delivers exceptional clarity and smoothness with its 4K@60Hz HDMI port, making it ideal for high-definition presentations and entertainment. (Note: Only the HDMI port supports video projection; the USB-C port is for data transfer only.)
- Double Up on Efficiency: The two USB-A 3.0 ports and a USB-C port support a fast 5Gbps data rate, significantly boosting your transfer speeds and improving productivity.
- Fast and Reliable 85W Charging: Offers high-capacity, speedy charging for laptops up to 85W, so you spend less time tethered to an outlet and more time being productive.
- What You Get: Anker USB-C Hub (7-in-1), welcome guide, 18-month warranty, and our friendly customer service.
- Select the complete affected range, including the full boundaries of every merged block.
- On the Home tab, open the Merge & Center control (or the Alignment controls).
- Choose Unmerge Cells.
- Check the resulting cells for headings, formulas, alignment and borders.
- Select the intended rectangular data range again and retry the command.
Microsoft’s general solution is to clear the Merge cells setting for the full range. Do not select only one visible portion of a larger block: leaving another merge in the operation can reproduce the same warning.
When is unmerging the better choice?
- The range is a table that users need to sort or filter repeatedly.
- Merges are being used only to center a title or make columns look wider.
- The workbook will be edited by several people and should have predictable row and column behavior.
- You can replace the visual effect with alignment, borders, row height or a separate title row.
Unmerging can change the visual layout, so review the copy rather than assuming the report still looks identical. If the upper-left cell was the only cell with content, the text normally remains in that cell after unmerging; the other cells are empty unless they had content that survived before the merge.
How do I keep merged cells and make them identically sized?
If the visual design depends on merged blocks, retain the merges but make every block included in the operation cover the same number of rows and columns. For instance, if each section label spans one row and three columns, every comparable section label in that selected range must also span one row and three columns.
- Use the Find All results to identify every merge in the operation’s range.
- Record each block’s row and column span by checking its start and end boundaries.
- Resize or recreate outlier blocks so their dimensions match the common pattern.
- Ensure the command’s selection includes whole merged blocks and no unrelated unmerged cells.
- Run the operation again on the complete rectangular range.
Matching dimensions can allow the operation to proceed, but it also imposes a maintenance rule: any future section added to that range must use the same shape. A single differently sized banner can reintroduce the warning.
Which repair should I choose?
The right choice depends on whether the merge is part of the data model or only part of the presentation.
| Situation | Preferred repair | Reason |
|---|---|---|
| Data rows need regular sorting or filtering | Unmerge the affected data range | Ordinary cells preserve a consistent row-and-column structure. |
| A report requires repeated visual section labels | Keep merges but use one identical row-by-column shape | The layout remains merged while Excel receives uniform blocks. |
| Only a title is merged above a data table | Exclude the title from the operation, or unmerge it | The data range can remain regular without changing the title. |
| A selection intersects only part of a merge | Reselect the full merged area or remove the merge | Operations must not cut through a merged block. |
| The workbook contains important labels or formulas | Save a copy, then inspect after either repair | Changing merge settings can alter layout and reveal misplaced content. |
How do I retry sorting or another blocked command?
After repairing the structure, start with a fresh selection rather than reusing the old one.
Also popular on Amazon
- Dual Converters, Infinite Potential：Includes 2× USB C male to USB A female adapters and 2× USB A male to USB C female adapters. Perfect for a wide range of uses—tablets with Bluetooth keyboards, expand USB ports on macbook, and more. Two different converters for all your daily needs
- Next-Level 10Gbps & 3A Charging: No more slow 480Mbps, this usb to usb c adapter has a transfer speed of up to 10Gbps, allowing you to do more transferring in less time. This usb adapter fits both USB A and USB C charger, supporting up to 3A fast charging
- Upgraded Exquisite Craftsmanship: With an aluminum alloy housing and metal connector, the usbc to usb adapter is extremely durable and sturdy. Rigorously tested to withstand more than 10,000 times of plugging and unplugging, ensuring long-lasting performance
- Broad Compatible: The usb c to usb adapter widely supports all USB C/ USB A devices like laptops, tablets, cellphones, car chargers, and phone chargers. Such as compatible with MacBook Pro/Air 2023/2022, Thunderbolt 4/3 Devices,Apple MagSafe Watch 9/8/7/SE/Ultra, iPad Pro 2022/2021, Samsung Galaxy S23/S20/S10, and iPhone 17/16/15 Pro. Plug and play
- Please Note: To reach 10Gbps speed, keep the cable under 3.3 ft. For USB A Male to USB C adapters, try flipping the USB C connector. USB C Male to USB A adapters support bidirectional 10Gbps transfer within 3.3 ft
- Click outside the previous selection.
- Select the complete rectangular range that the command should affect.
- Confirm that no merged block is partly included and that all remaining merged blocks have equal dimensions.
- Run the command again, such as Sort, Filter, copy, insert or formatting.
- Review the result for shifted labels, formulas and borders.
If the warning returns, use Find & Select > Find > Format > Alignment > Merge cells > Find All again and compare every result with the selected range. The remaining conflict is usually a merge that was outside the first repair selection or a block with a different height or width.
Does the fix differ between desktop, Mac and web Excel?
The underlying rule is the same: a command cannot use a range containing incompatible merged geometry. Interface names and the location of the merge control can vary by Excel edition, so look for the Home tab’s merge/unmerge command and the Find and Select format search. If a command is unavailable in a particular interface, open the workbook in an edition that exposes the full merge and format-search controls, make the structural repair there, save it, and then continue editing in the preferred edition.
Recommended Free Tools
Regardless of edition, preserve a copy before unmerging and verify the resulting layout. A workbook can display correctly while still containing a hidden merge elsewhere in the range that blocks the next operation.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.How can I prevent the message in new workbooks?
Use merges for presentation-only headings, not for the body of a sortable data table. Keep one record per row and one field per column in operational ranges. Put a title or section banner in a separate row above the data, or use alignment and borders to create a grouped appearance without changing the grid.
- Define the data range without decorative headings before sorting.
- Apply one consistent merge shape to repeated report sections.
- Check new labels against existing merge dimensions before copying a section.
- Run the Find All merge search during workbook cleanup.
- Keep a clean, unmerged data sheet and a separate formatted presentation sheet when both goals are important.
This separation prevents a visual heading from becoming part of the record range and makes future sorting, filtering and copying predictable.
What should I do if unmerging changes the appearance?
First undo immediately if you are still in the same editing session and the result is clearly wrong. Otherwise reopen the saved copy and plan the repair with the layout in view. After unmerging, restore the intended appearance with horizontal and vertical alignment, borders, column widths, row heights or a dedicated title row rather than recreating inconsistent merges inside the data range.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Also popular on Amazon
- 5-in-1 Connectivity: Equipped with a 4K HDMI port, a 5 Gbps USB-C data port, two 5 Gbps USB-A ports, and a USB C 100W PD-IN port. Note: The USB C 100W PD-IN port supports only charging and does not support data transfer devices such as headphones or speakers.
- Powerful Pass-Through Charging: Supports up to 85W pass-through charging so you can power up your laptop while you use the hub. Note: Pass-through charging requires a charger (not included). Note: To achieve full power for iPad, we recommend using a 45W wall charger.
- Transfer Files in Seconds: Move files to and from your laptop at speeds of up to 5 Gbps via the USB-C and USB-A data ports. Note: The USB C 5Gbps Data port does not support video output.
- HD Display: Connect to the HDMI port to stream or mirror content to an external monitor in resolutions of up to 4K@30Hz. Note: The USB-C ports do not support video output.
- What You Get: Anker 332 USB-C Hub (5-in-1), welcome guide, our worry-free 18-month warranty, and friendly customer service.
Check every formula and label that was visually centered in the old merged cell. Because only the upper-left cell represents the visible merged content, the value you need may now be at the first cell of the former block. Validate the report before distributing the repaired workbook.
Frequently Asked Questions
Can I sort a range that has one merged title above it?
Yes, if the title row is excluded from the sort range. Select only the consistently structured data rows; including the merged title in that rectangle can trigger the warning even when the data itself has no merges.
Will unmerging restore text that was in every original cell?
No. During the original merge, Excel kept the upper-left cell’s visible content and deleted content from the other cells. Unmerging restores the grid, but it does not recreate text or formulas that were removed.
Why does the error appear after I add a new section to a report?
The new section may use a different merge width or height from existing sections. Compare its boundaries with the established pattern and either make the dimensions identical or leave the section outside the operation’s selected range.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Is a merged cell the same as a larger column?
No. A merge combines multiple grid cells into one display area while preserving the underlying row-and-column structure. Widening a column changes its display width without creating a multi-cell block, so it does not create this particular merge-dimension conflict.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
