Unmerge Cells in Excel

How to Unmerge Cells in Excel

1. Upload your Excel file — click the upload zone or drag and drop your .xlsx / .xls file.
2. Review merged cells — the tool scans your file and shows how many merged cell ranges were found, plus a preview of your data.
3. 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.
4. Click "Unmerge All Cells" — the tool processes every merged range in one bulk operation.
5. 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.

How to Unmerge All Cells at Once in Excel

Desktop Excel has no built-in "unmerge everything" button. To remove cell merging manually, select one merged range, open the Home tab, and click Unmerge Cells — then repeat for every other range on the sheet. When a worksheet contains dozens of merged headers, that is slow and error-prone, and a range hiding off-screen is easy to miss.

A bulk unmerge tool fills that gap. This tool scans the entire workbook in one pass, finds every merged range across every sheet, and splits them all at once with a single click. The preview highlights merged cells in yellow so they are easy to spot before committing.

One distinction worth knowing: Merge & Center and Center Across Selection are different things. Center Across Selection only centers text visually across a row — it does not merge cells, so there is nothing to unmerge and no risk of data loss. True merged cells, where a single value spans multiple rows or columns, are what this tool removes.

Unmerge Cells Without Losing Data

A merged cell holds its value in only one place: the top-left cell of the range. The moment cells are merged, Excel keeps the top-left value and discards everything else in the range. That is why splitting a merged cell with Excel's own Unmerge Cells command leaves the value in the top-left cell and blanks everywhere else.

If the value only needs to live in one place, that default behavior is fine. But when a merged header should stay readable in every cell — or when the sheet is being exported to another tool that does not understand merges — the value needs to be repeated. The Fill values into unmerged cells option copies the original top-left value into every cell that belonged to the merge, so nothing is lost in the split.

That is the difference between unmerging and unmerging without losing data. The tool leaves the rest of the workbook — formatting, formulas, and other sheets — untouched.

Why Is "Unmerge Cells" Greyed Out in Excel?

The Unmerge Cells button sits greyed out for a few common reasons, and none of them are bugs. First, the selected cells may not be part of a merged range — Excel greys the option out because there is nothing to unmerge. Second, the worksheet may be protected; open Review → Unprotect Sheet and try again. Third, the workbook may be a shared workbook, which disables merging and unmerging until sharing is turned off. Fourth, a cell may still be in edit mode; press Esc to leave the cell, then select the range again.

A browser-based unmerge tool sidesteps these limits. Because the file is processed locally, worksheet protection, shared-workbook state, and ribbon availability do not apply — the merged ranges are read directly from the file and split regardless. When a file opens here but not in Excel, this is often the fastest way to get the job done.

Unmerge Cells in Google Sheets

Google Sheets unmerges one range at a time: select the merged cell, open Format → Merge cells → Unmerge, and only that range is split. When a sheet has dozens of merged headers, repeating this for every range is slow, and a range hiding off-screen is easy to miss.

For bulk work there is a faster path: in Google Sheets choose File → Download → Microsoft Excel (.xlsx), then drop the downloaded file into the tool above. It finds every merged range across every sheet and splits them all in one batch — with the option to fill values so nothing is lost. The processed .xlsx can be re-uploaded into Google Sheets or opened in any spreadsheet app.

FAQ

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