Unmerge Cells in Excel

Upload an Excel file (.xlsx or .xls), find all merged cells, and unmerge them in one click. Choose whether to fill the value into every unmerged cell or leave them blank. Everything runs locally — your file never leaves your device.

📁

Click to upload or drag & drop an Excel file here

Supports .xlsx (100% formatting preserved) and .xls (converted to .xlsx). Processed locally — never uploaded.

How to Unmerge Cells in Excel

Upload your Excel file — click the upload zone or drag and drop your .xlsx / .xls file.
Review merged cells — the tool scans your file and shows how many merged cell ranges were found, plus a preview of your data.
Choose your option — toggle "Fill values" on (recommended) to copy the merged cell's value into every resulting cell. Turn it off if you want only the top-left cell to keep its content.
Click "Unmerge All Cells" — the tool processes every merged range in one bulk operation.
Download the result — save the unmerged .xlsx file back to your computer.

Features

Bulk unmerge — unmerge all merged cells in your entire workbook at once, not one by one.
Fill values on unmerge — when you split a merged cell, the value is copied to every cell that was part of the merge. No more "data disappeared" surprises.
Multi-sheet support — works on every sheet in your workbook. Switch between sheets to preview each one.
Privacy-first — your file is processed entirely in your browser using JavaScript. No upload to any server. No signup required.
100% formatting preserved — colors, fonts, borders, number formats, charts, and images all stay exactly as they are. The tool only removes the merge definitions.
Works on Mac, Windows, and Linux — it's a web tool, so any modern browser works. No Excel installation needed.
Free with no limits — no file size cap beyond what your browser can handle. No daily usage limits.

FAQ

How do I unmerge cells in Excel without losing data?

When you unmerge cells in Excel desktop, only the top-left cell keeps its value — all other cells in the merged range become empty. Our tool solves this: enable "Fill values into unmerged cells" and every cell that was part of the merge will contain the original value. This is the equivalent of using a VBA macro to unmerge-and-fill, but without writing any code.

Is there a shortcut to unmerge cells in Excel?

In Excel desktop, the shortcut is Alt + H + M + U (Windows) or selecting "Unmerge Cells" from the Home ribbon. However, this only works on one merged range at a time. For bulk unmerging an entire sheet with dozens or hundreds of merged ranges, our tool is much faster.

How do I unmerge cells in Excel on a Mac?

On Excel for Mac, select the merged cell, go to the Home tab, click the arrow next to Merge & Center, and choose Unmerge Cells. There is no default keyboard shortcut on Mac. Our web tool works identically on Mac, Windows, and Linux — just upload and click.

Can I unmerge cells in bulk across multiple sheets?

Yes. Our tool scans every sheet in your workbook and unmerges all of them at once. If you only want to unmerge specific sheets, you can delete the other sheets in Excel first, then upload.

Is my data safe? Where does my file go?

Your file never leaves your computer. All processing happens locally in your browser using JavaScript (the SheetJS library). There is no upload to any server, no cloud processing, and no one can see your data. You can verify this by disconnecting your internet after the page loads — the tool still works.

How do I unmerge cells and fill down in Excel with VBA?

If you prefer to use VBA, here's a macro that unmerges all cells in the active sheet and fills values:

Sub UnmergeAndFill()
    Dim c As Range
    For Each c In ActiveSheet.UsedRange
        If c.MergeCells Then
            Dim v As Variant, r As Range
            v = c.MergeArea.Cells(1, 1).Value
            Set r = c.MergeArea
            c.UnMerge
            r.Value = v
        End If
    Next
End Sub

Our tool does the same thing — without needing to open the VBA editor.