How to Unmerge Cells in Excel (Group of Cells)

How-to basics · Updated November 22, 2026

To unmerge a group of cells in Excel, select the merged cell (or range of merged cells), then go to the Home tab, click Merge & Center in the Alignment group, and choose Unmerge Cells. Alternatively, select the merged cell and press Ctrl+Z immediately after merging, or use the shortcut Alt+H+M+U (Windows) or Ctrl+Option+M+U (Mac) to unmerge without touching the mouse.

Why Merged Cells Cause Problems

Merged cells are a common source of frustration in Excel because they break many standard operations. When you merge two or more cells, only the top-left cell’s value is kept; all other selected cells become empty and are essentially hidden. This affects sorting, filtering, copying, and even basic navigation—pressing Tab or arrow keys skips over the merged area, and selecting a range that includes merged cells often produces unexpected errors. Understanding why you might want to unmerge is the first step: unmerging restores each cell to its own address, making your data behave like a normal grid again.

For example, if you have a merged cell A1:B1 containing “Sales”, unmerging it will put “Sales” in A1 and leave B1 empty. If you need the text to span both columns visually without the structural issues, you can use Center Across Selection (see the Alternatives section below).

How to Unmerge a Single Merged Cell

The quickest method for a single merged cell is the ribbon command:

  1. Click the merged cell you want to unmerge.
  2. Go to the Home tab.
  3. In the Alignment group, click the Merge & Center button (the small arrow next to it if you have a dropdown).
  4. Select Unmerge Cells from the dropdown menu.

This works in Excel for Microsoft 365, Excel 2021, 2019, and earlier versions on Windows. On a Mac, the steps are identical: Home tab > Merge & Center > Unmerge Cells. The keyboard shortcut Alt+H+M+U works on Windows; on Mac, press Ctrl+Option+M+U.

How to Unmerge All Merged Cells in a Sheet

If your worksheet has many merged cells scattered across it, unmerging them one by one is tedious. Here’s a quick method to unmerge all of them at once:

  1. Select the entire worksheet by clicking the triangle at the top-left corner (where the row numbers and column letters meet), or press Ctrl+A (Windows) / Cmd+A (Mac) a few times until the whole sheet is selected.
  2. Go to Home > Merge & Center > Unmerge Cells.

This unmerges every merged cell in the sheet in one action. Be careful: if any merged cells had data in cells other than the top-left, that data will be lost (though it was already lost when the merge happened—only the top-left value remains). After unmerging, all cells revert to their individual addresses, and any values that were in the top-left cells stay there.

Using Find & Select to Locate Merged Cells

Before unmerging, you might want to find all merged cells to review them. Excel has a built-in way to select merged cells:

  1. Press Ctrl+G (Windows) or Cmd+G (Mac) to open the Go To dialog.
  2. Click Special.
  3. Choose Merged cells and click OK.

This selects all merged cells in the current range (or the entire sheet if you had a single cell selected). Then you can unmerge them all using the ribbon method above. This is especially useful when you want to inspect which cells are merged before deciding to unmerge everything.

Common Problems When Unmerging

Several issues can arise when unmerging, and knowing them in advance saves time:

  • Data loss: When you unmerge, only the top-left cell’s content remains. If you had data in other cells before merging (which Excel would have discarded with a warning), that data is gone. Always check the top-left cell after unmerging.
  • Merged cells in formulas: If a formula references a merged range, unmerging can break the reference. For example, if you had =SUM(A1:B1) and A1:B1 was merged, unmerging doesn’t change the formula, but if you had a formula in B1 that was overwritten during merge, it’s lost.
  • Copy-paste issues: Copying a merged cell and pasting it elsewhere may create merged cells in the destination. To avoid this, unmerge first, then copy.
  • Sorting/filtering errors: Merged cells can cause “This operation requires the merged cells to be identically sized” errors when sorting. Unmerging before sorting solves this.
  • Keyboard navigation: After unmerging, arrow keys and Tab will move through every cell normally again.

Alternatives to Merging (Center Across Selection)

If you’re unmerging because merged cells are causing problems, consider using Center Across Selection instead. This feature centers text across multiple cells without actually merging them—so the cells remain individual and all standard operations work normally.

  1. Select the cells you want to center across (e.g., A1:D1).
  2. Press Ctrl+1 to open Format Cells.
  3. Go to the Alignment tab.
  4. Under Horizontal, choose Center Across Selection from the dropdown.
  5. Click OK.

This visually centers the text across the selected cells, but the cells remain unmerged. The text stays in the leftmost cell, and you can still select, sort, and filter without issues. This is a great alternative for headings and labels.

Using VBA to Unmerge Cells (Advanced)

If you need to unmerge cells frequently or as part of a larger automation, you can use a simple VBA macro. Here’s a basic example that unmerges all merged cells in the active sheet:

Sub UnmergeAllCells()
    Dim cell As Range
    ' Loop through each cell in the used range
    For Each cell In ActiveSheet.UsedRange
        If cell.MergeCells Then
            ' Unmerge the merged area (this also resets the range)
            cell.MergeArea.Unmerge
        End If
    Next cell
End Sub

Before running any macro, save a copy of your workbook because macros cannot be undone with Ctrl+Z. To use it, press Alt+F11 to open the VBA editor, insert a new module, paste the code, and run it. This is useful for cleaning up imported data or templates.

Frequently Asked Questions

Does unmerging cells delete data?

Unmerging itself does not delete data, but it only keeps the value from the top-left cell. If other cells in the merged range had data before merging, that data was already lost when the merge occurred. After unmerging, the top-left value remains; the other cells become empty.

Can I unmerge cells without losing the centered look?

Yes, use Center Across Selection as described above. It keeps the visual effect of merged cells while maintaining individual cell structure.

Why can’t I unmerge cells in Excel?

If the Unmerge option is grayed out, the cell you selected might not actually be merged. Check that you have selected a merged cell (it will span multiple columns/rows). Also, if the sheet is protected, you may need to unprotect it first (Review tab > Unprotect Sheet).

How do I unmerge cells on Excel for the web?

In Excel for the web, select the merged cell, go to the Home tab, and click the Merge & Center button—it toggles between merge and unmerge. There is no dropdown; clicking it once unmerges if the cell is merged.

What happens to cell references when I unmerge?

Cell references in formulas are not automatically adjusted. If a formula referenced the merged range (e.g., =A1+B1), it still refers to those individual cells after unmerging. If the formula referenced a merged cell by its top-left address, it continues to work. However, if you had a formula in a non-top-left cell that was overwritten during merge, it’s gone.

Can I unmerge all merged cells in a specific range only?

Yes, select the range first, then use the ribbon command Home > Merge & Center > Unmerge Cells. Only merged cells within that selection will be unmerged.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.