Formatting Issues

Fix Excel Filter Error: Merged Cells Exist But None Found

Maira Mehtab Sep 20, 2026 871 views

Question details

The user is unable to sort or filter a column in their workbook because Excel indicates that merged cells must be identically sized, but the search tool finds no merged cells.

Product: Microsoft Excel 365
Device & OS: not provided
Scenario: Attempting to apply a filter or sort data by Column A in a standard worksheet.
Observed behavior: Excel displays an error stating that all merged cells must be the same size and blocks the sorting action, contradicting the 'Find All' tool which reports that no merged cells exist in the worksheet.

Before you start

Before troubleshooting, ensure you have cleared any active data filters and unhidden all rows and columns to verify no hidden formatting irregularities are triggering the error.

Solution 1Recommended

Force Unmerge the Entire Worksheet

The fastest way to bypass undetected merged cells is to manually apply the unmerge command across the entire worksheet.

Excel's 'Find All' tool can sometimes miss merged cells if the format search criteria are incomplete or corrupted. Forcing an unmerge on all cells guarantees that no hidden structural conflicts remain.

Select the entire sheet

Click the triangle icon in the top-left corner of your worksheet (where the row numbers and column letters intersect) or press Ctrl + A to highlight all cells.

Unmerge all cells

Navigate to the 'Home' tab on the Excel ribbon, click the dropdown arrow next to 'Merge & Center' in the Alignment group, and select 'Unmerge Cells'.

Retry sorting

Highlight your target data, go to the 'Data' tab, and attempt to sort or filter Column A again.

Formatting Retained: Unmerging cells will simply split combined cells back into individual cells; it will not delete your data, though you may need to adjust column widths.

Solution 2

Copy Data as Values to a Clean Worksheet

If background formatting glitches persist, pasting the raw data into a new worksheet removes all problematic cell structures instantly.

Solution 3

Clear Formats from the Target Range

Clearing all formatting rules can resolve corrupt background structures that 'Find All' fails to detect.

Sort Data Without Glitches

Easily Manage and Sort Spreadsheets in WPS Office

If Excel's formatting glitches and merged cell limitations disrupt your workflow, try WPS Office. Its Spreadsheet application accurately detects formatting, unmerges cells easily, and sorts large datasets smoothly without false error prompts.

1. Open your workbook in WPS Spreadsheet: Launch WPS Office, click 'Open', and select your existing .xlsx file to edit it seamlessly.
2. Unmerge hidden cells: Press Ctrl + A to select the sheet, go to the 'Home' tab, and click the 'Merge and Center' icon to instantly clear any hidden merged layouts.
3. Sort data smoothly: Highlight your target columns, navigate to the 'Data' tab, and click 'Sort' to organize your data flawlessly.

100% free and fully compatible with Microsoft Excel (.xlsx, .xls) formatsClearly identify and unmerge problematic cells in just a few clicksAdvanced sorting and filtering without standard standard software glitchesFamiliar user interface requiring no learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say merged cells must be the same size?

This error is triggered when you attempt to sort a data range that contains merged cells of varying dimensions. Excel requires all cells within a sorted range to be individual (unmerged) or merged in exactly the same uniform layout to maintain the data structure.

Why didn't the 'Find All' tool locate my merged cells?

Excel's 'Find' tool might miss merged cells if the format search criteria were incomplete, if the cells are hidden within collapsed groups or filtered rows, or if a software cache glitch prevents it from recognizing the formatting.

Is there a shortcut to unmerge all cells in a worksheet?

Yes. Press Ctrl + A to select the entire spreadsheet, navigate to the Home tab, click the drop-down arrow beside Merge & Center, and select 'Unmerge Cells'. This overrides all merged formats at once.

Document & File Issues