Unmerge Cells in Excel

Unmerge every merged cell in a workbook and fill each one with the merged value, so the data sorts, filters and pivots. Runs in your browser - nothing is uploaded.

Drop your file here or choose a file

Opened on your device - never uploaded · up to 50MB

Choose file

Supports .xlsx, .xls, .xlsm, .xlsb · or paste a file from your clipboard

No file handy? · download it

Why Merged Cells Break Sorting and Filtering

A report often merges a region or a month down the rows it covers. It reads well, but Excel stores the label only in the top-left cell; every other cell of the merge is empty. Sorting refuses to run ("all the merged cells need to be the same size"), a filter on the label finds only the first row, and a pivot table counts the rest as blank. Unmerging alone does not fix it, because the blanks stay blank.

What This Tool Does

It removes every merged range on every sheet and, by default, writes the merged value into each cell the range covered, with the same number format. Covered cells that already hold a value of their own keep it. The before and after previews show the first rows of each sheet so you can check the result before downloading.

To clear fonts, fills and alignment as well, use Remove Formatting; to drop the empty spacer rows reports leave, use Remove Blank Rows.

Frequently Asked Questions

Related Tools