Microsoft Excel: How to Unmerge Cells and Fix Layouts

Errors & fixes · Updated November 20, 2026

To unmerge cells in Excel for Microsoft 365 on Windows, select the merged cell or range, then choose Home > Merge & Center ▼ > Unmerge Cells. Excel keeps the merged cell’s value in its upper-left cell and leaves the other cells in the former merge blank.

Unmerge cells with the Home tab

The unmerge command is in the same menu used to merge cells. Select a merged cell, or drag across a range that includes merged cells, and open the drop-down arrow beside Merge & Center on the Home tab. Choose Unmerge Cells. If you select several cells, Excel unmerges any merged areas included in the selection; ordinary, unmerged cells are not changed.

You can also use the ribbon KeyTips on Windows: press Alt, then H, M, and U in sequence. KeyTips can vary with ribbon configuration or Excel updates, so if that sequence does not work, use the visible menu path. There is no need to copy or cut the cell first.

  • One merged cell: click anywhere inside it, then choose Unmerge Cells.
  • Several merged cells: select a range containing them, then choose Unmerge Cells once.
  • A whole worksheet: click the Select All button at the intersection of the row and column headings, then choose Unmerge Cells. This changes merged cells throughout the sheet, so use it only if you intend to unmerge all of them.

What happens to the cell contents

A merged range behaves like one large cell for its contents. Excel stores the value in the range’s upper-left cell. For a merge covering B2:D2, for example, the displayed text belongs to B2. When you unmerge the range, B2 keeps that value, while C2 and D2 become separate blank cells. Excel does not divide a heading across the cells or copy it into every newly available cell.

This behavior matters if you expect unmerging to bring back data that was present before the cells were merged. When cells are merged, Excel warns that it keeps only the upper-left cell’s contents and discards contents in the other cells. Unmerging cannot recover those discarded values. If you have just merged the cells and have not made other changes, press Ctrl+Z on Windows to undo the merge. Otherwise, try a saved earlier version, a backup, or another source of the missing data.

Unmerging is not the same as deleting cells or clearing a range. It separates the cells again without shifting nearby rows or columns. The upper-left value remains in place; the other cells become available for entry, formulas, or sorting.

Unmerge a selected range or an entire sheet

To unmerge several areas at once, select the worksheet region that contains them, then use the Unmerge Cells command. The selection can include both merged and ordinary cells. This is useful when cleaning up a report or a copied table, but check the selection carefully: the command affects every merged area within it, including headings you might have wanted to keep merged.

To select the whole sheet, click the small triangle above row 1 and to the left of column A. You can also use Ctrl+A on Windows, although the first press inside a data region may select only that region; press it again if needed to select the entire worksheet. Then use Home > Merge & Center ▼ > Unmerge Cells. Review the sheet afterward, since broad selection can change the layout of multiple tables at once.

If you need to preserve some merged headings, work on a specific range instead of selecting the entire sheet. You can also unmerge one area at a time so that you can check the result before continuing.

How to keep or restore information in the blank cells

After unmerging, you may want the former merged area to contain the same label in each cell. For a small range, enter the value into the upper-left cell, copy it, select the other cells, and paste. Alternatively, type the value into a selected range and press Ctrl+Enter on Windows to enter the same text into all selected cells. Check that you selected only the intended cells before using this method.

If you need different values in the cells, enter them individually or restore them from a source that still contains the original data. For example, if B2:D2 was merged and the original row should read “North,” “Central,” and “South,” unmerging leaves “North” in B2 and blanks in C2 and D2. You must supply “Central” and “South” from a reliable source; Excel cannot infer them from the merged heading.

Before making a large change, consider saving a copy of the workbook or duplicating the worksheet. This gives you a reference for the original layout and contents. It is especially helpful when the workbook contains several related tables or when you are not sure whether merged cells contain useful labels.

Find merged cells in a worksheet

If you do not know where the merged cells are, Excel’s Find dialog can search by formatting. On Windows, open Home > Find & Select > Find, select Options if the additional settings are hidden, then choose Format. In the Format dialog, open the Alignment tab and select Merge cells. Confirm the dialogs and choose Find All to list matching cells. You can select results in the list, but inspect the worksheet before applying a change because a search can return multiple matches.

Another practical approach is to select a likely table or report area and look at the Merge & Center control. The command’s displayed state can help identify that the active cell is merged, but it is not a reliable inventory of every merged cell in a large workbook. Searching by format or checking sections individually is safer when a sheet has a complicated layout.

Common problems and what to check

  • The command is unavailable: confirm that you selected a cell or range on the worksheet, not a chart or another object. If the sheet is protected, go to Review > Unprotect Sheet if you have permission and the password, then try again.
  • Only one area changed: check whether the other merged cells were inside the selected range. Select the broader intended area and repeat the command.
  • Text appears only in one cell: this is expected. The upper-left cell retains the value; the other cells are blank after unmerging.
  • The layout still looks unusual: unmerging does not automatically restore the original column widths, row heights, borders, or alignment. Adjust those separately using the Home tab and the row or column headings.
  • You lost values when merging: unmerge first if necessary, then use Undo if the merge was your most recent action. Otherwise, look for a backup or earlier saved version; unmerging itself does not restore values discarded during the merge.

Excel may retain formatting on the cells when a merged range is separated, but do not assume it has recreated each cell’s former formatting. Check borders, fill, alignment, and number formats, particularly if the range is part of a printed report. Formatting changes are separate from the contents of the cells.

When to unmerge—and what to use instead

Merged cells can make a heading appear centered over several columns, but they can complicate sorting, filtering, selecting, and pasting within a table. A merged cell can also make rows uneven or cause Excel to reject an operation that expects each row to have the same structure. For data intended for analysis, it is usually easier to work with one value per cell and avoid merges inside the table.

If you want a heading centered across columns without merging them, select the cells and open the Format Cells dialog with Ctrl+1 on Windows. On the Alignment tab, set Horizontal to Center Across Selection. This visually centers the text across the selected cells while keeping them separate. It is useful for presentation headings, although it is not the same as centering content vertically across a merged range.

For a simple heading, another option is to place the text in one cell and adjust its alignment, column widths, or indentation. Choose an approach based on how the sheet will be used: a visually formatted report may have different needs from a sortable list or a table used for calculations.

Excel for Mac and Excel for the web

In Excel for Mac, select the merged cell or range and use the Home tab’s Merge & Center drop-down, then choose Unmerge Cells. Ribbon placement can differ slightly by window size or version. The Windows Alt KeyTips sequence is not the Mac shortcut; use the ribbon menu or the Mac menu and shortcut options available in your installed version.

In Excel for the web, select the merged cells, open the Home tab, and use the Merge & Center menu to choose Unmerge Cells. The web interface may arrange ribbon controls differently from desktop Excel, but the result is the same: the upper-left cell retains the content and the rest become blank. If a command is missing or the workbook is restricted, open it in the desktop app or check the sheet’s protection and editing permissions.

Frequently Asked Questions

Can I unmerge cells without losing data?
Unmerging keeps the value in the upper-left cell and leaves the other cells blank. It does not discard that remaining value, but it cannot restore values that were discarded when the cells were originally merged.

How do I unmerge all cells in Excel?
Select the whole worksheet with the Select All button above row 1 and beside column A, then choose Home > Merge & Center ▼ > Unmerge Cells. This affects every merged area on that sheet, so save a copy first if you may need the original layout.

Why is Unmerge Cells grayed out?
You may not have selected a merged cell, or the worksheet may be protected. Select the relevant cells and check Review > Unprotect Sheet. If protection requires a password, you need appropriate access before changing the sheet.

Does unmerging fill the former cells with the same text?
No. The text remains only in the upper-left cell. Copy it into the other cells or enter new values if you want the former merged range populated.

Can I unmerge cells in Excel for the web?
Yes. Select the merged cell, open the Home tab’s Merge & Center menu, and choose Unmerge Cells. The resulting contents follow the same upper-left-cell rule as in desktop Excel.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.