Excel Unmerge Cells Shortcut: Keys, Steps, and Fixes

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select a merged cell and press Alt, H, M, U—one key after another, not all at once—to unmerge it. Excel restores the separate cells, but keeps the cell contents only in the upper-left cell of the former merged area.

The Windows shortcut and what each key does

The sequence Alt, H, M, U uses Excel’s ribbon Key Tips. Pressing Alt displays letters for ribbon tabs; H opens Home, M opens the Merge & Center menu, and U chooses Unmerge Cells. The sequence is a quick route to the same command available through the ribbon.

Use it when the active cell is merged or when you have selected a range that includes merged cells you want to separate. If the letters shown on your screen differ, follow the Key Tips Excel displays: the sequence can vary with the ribbon interface, language, or version. Pressing Esc cancels a Key Tip sequence if you opened the wrong menu.

After unmerging, the command can usually be reversed immediately with Ctrl+Z, just like other worksheet edits. Undo is useful if you selected too much or did not expect the result. It is not a substitute for checking the selection first, especially in a workbook with important data or formatting.

How to unmerge cells from the ribbon

If you would rather use the mouse, the ribbon path in Excel for Windows is Home > Merge & Center ▼ > Unmerge Cells. The small arrow beside Merge & Center opens its menu. Depending on ribbon width, the button may appear in the Alignment group as a compact icon or label.

  1. Click a cell in the merged area. You do not need to select each underlying cell individually.
  2. On the Home tab, open the Merge & Center dropdown.
  3. Choose Unmerge Cells.
  4. Check the cells that were part of the merged area, especially the upper-left cell and any cells where you expected data.

You can also select a range containing merged areas before using the command. Take care with broad selections: a command applied to a large range may unmerge more areas than intended. If you only want to change one heading, click that heading’s merged cell rather than selecting the whole row or sheet.

What happens to data and formatting

Unmerging changes the cell structure; it does not divide the original text among the newly separate cells. A merged range such as B2:D2 is treated as one displayed cell. If it contains the label Quarterly sales, that content is stored in B2, the upper-left cell. After unmerging, the label remains in B2, while C2 and D2 are blank. Excel does not copy the label into all three cells.

This is the key point behind a common misconception: unmerge does not restore values that were in the other cells before the merge. When cells are merged, Excel retains the upper-left cell’s content and removes contents in the other cells. If data was overwritten or discarded during the original merge, unmerging cannot bring it back. Use Undo immediately after a merge if you need to recover the prior state, or restore from a saved copy or version history if the change is no longer in the undo history.

Formatting and appearance are separate from cell contents. The cells become individually addressable again, but do not assume their formatting will return to exactly how it looked before the merge. Check alignment, borders, fill, number format, and wrapping after unmerging. A border may still visually span several cells, for example, even though those cells are no longer merged.

Unmerge also does not insert or delete rows and columns. It simply restores the cells in the selected merged area as separate grid cells. Formulas and references that pointed to the merged cell may still need review if the worksheet’s layout or intended data structure has changed.

Excel on Mac and Excel for the web

The Alt, H, M, U sequence is for Excel on Windows. Excel for Mac has different keyboard conventions, and there is not a directly equivalent standard shortcut sequence to rely on across Mac keyboards and versions. On a Mac, select the merged cell and use the Home tab’s Merge & Center dropdown, then choose Unmerge Cells. The command may be displayed as a compact ribbon button depending on the window size.

In Excel for the web, select the merged cell and use Home > Merge & Center > Unmerge Cells. The ribbon layout can vary with the browser window, so expand the dropdown if the unmerge option is not visible. If the workbook is open in a browser and the command is unavailable or the layout is difficult to manage, open it in the desktop app if you have access to Excel for Windows or Mac.

These differences matter because a shortcut found in a Windows guide may do something else—or nothing—on a Mac. The ribbon command is the dependable cross-platform approach; use the Windows Key Tip sequence only when working in Excel for Windows.

Common problems and practical fixes

  • The command is greyed out: Check that the active cell or selected range actually contains a merged cell. If the worksheet is protected, editing may be restricted; review the Review tab for sheet protection and ask the workbook owner before changing protection settings.
  • The shortcut opens the wrong option: Press the keys in sequence, allowing the ribbon to respond between them. Start with Alt, then follow the letters shown on screen. Esc cancels the sequence so you can begin again.
  • The text appears to vanish: Look in the upper-left cell of the former merged range. That is where Excel keeps the surviving content. Also check whether the text is hidden by column width, row height, or formatting rather than assuming it was deleted.
  • The layout still looks merged: Inspect the cell boundaries and alignment. Borders can make separate cells look like one block. Click a cell and check whether the Merge & Center control indicates that the selection is merged.
  • You cannot select a cell inside the range: Click the merged area once; Excel treats the merged region as a single selectable cell. After unmerging, individual cells can be selected normally.

If the workbook is shared or contains a carefully formatted report, save a copy before making a large change. A small test on a copied sheet can show whether the resulting layout and data meet your needs without affecting the original.

Unmerging multiple areas and checking the result

To unmerge several areas together, select a range that contains those merged cells, then use the ribbon command or the Windows shortcut. For example, if several title cells are merged across columns A through D in a report, select the report region containing those titles and choose Unmerge Cells. Review the result afterward: each former merged area will have its own cells, and only its upper-left cell will retain the content.

For a whole worksheet, selecting the entire sheet and invoking Unmerge Cells can be a quick way to remove merged areas, but it is a broad edit. It may disrupt headings, print layouts, or carefully arranged forms. Save a copy first and consider limiting the selection to the relevant section. There is no need to unmerge cells that are working as intended.

When checking a large workbook, focus on places where merged cells affect sorting, filtering, copying, or editing. Merged cells can make rectangular selections and data operations awkward, so removing them may solve a workflow problem. Still, inspect each region for content and layout rather than treating unmerge as a purely cosmetic change.

Alternatives to merging cells

If the goal is to center a heading across several columns, merging is not the only option. In Excel for Windows, select the cells and open Format Cells with Ctrl+1. On the Alignment tab, choose Center Across Selection in the Horizontal list. This displays text centered across the selected columns without combining the cells into one merged cell. It can make sorting, selecting, and editing nearby data easier.

Another simple choice is to put the heading in one cell and adjust column widths, alignment, or text wrapping so it fits. For a table intended for filtering or analysis, keep one value per cell and avoid merging cells within the data area. Merging is often better suited to decorative titles or report headings than to a structured list.

If you need to retain the same label in several cells after unmerging, fill those cells deliberately rather than expecting Excel to duplicate it. Copy and paste the value, or enter it separately where appropriate. Before doing so, consider whether repeated text could create confusion in a table or affect later sorting and analysis.

Frequently Asked Questions

What is the keyboard shortcut to unmerge cells in Excel?
In Excel for Windows, select a merged cell and press Alt, H, M, U in sequence. On Mac, use the Home tab’s Merge & Center dropdown and choose Unmerge Cells.

Does unmerging restore the values from every cell?
No. Only the content from the upper-left cell remains after a merge and subsequent unmerge. Other content removed when the cells were originally merged is not restored by unmerging.

Can I unmerge all merged cells at once?
You can select a range or the whole worksheet and use Unmerge Cells. Because this can alter many headings and layouts, save a copy and verify the selection before applying it broadly.

Why does the unmerge command appear unavailable?
The selected cell or range may not contain a merged cell, or the worksheet may be protected. Select the merged area itself and check whether editing is permitted.

Can I split a merged cell into separate cells with their old contents?
Unmerge restores the underlying grid cells but does not recreate discarded values or split the text. Recover earlier contents through Undo, a backup, or workbook version history if available.

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.