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 fileTap to choose a file
Opened on your device - never uploaded · up to 50MB
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
Select the merged cells, then on the Home tab open the Merge & Center menu and choose Unmerge Cells (on Windows the keys are Alt, H, M, U). Select the whole sheet first to unmerge everything. Excel keeps the value in the top-left cell and leaves the others blank.
After unmerging, select the range, use Home > Find & Select > Go To Special > Blanks, type = and press the up arrow, then Ctrl+Enter, and finally copy the range and paste it as values. That works for ranges merged down a column; this tool fills ranges merged across rows, columns or both in one step, on every sheet.
The top-left cell keeps its formula. The other cells get the formula's result as a value, because a copied formula's relative references would shift and calculate something else in each cell.
For an .xlsx or .xlsm file, yes: the result is written into your own file, so charts, pivot tables, conditional formatting, data validation, comments and macros come through unchanged. An .xls or .xlsb file is saved as a new .xlsx built from the cells, formatting and layout, and the result says so.
No. The workbook is read and rewritten in your browser.