Excel Unmerge Shortcut: How to Unmerge Cells on Windows

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select a merged cell and press Alt, H, M, U to unmerge it. Press the keys in sequence, not all at once; the same command is available from Home > Merge & Center > Unmerge Cells.

The Windows shortcut and what the keys do

Alt, H, M, U is an Excel ribbon KeyTip sequence. Pressing Alt displays KeyTips, H opens the Home tab, M opens the Merge & Center menu in the Alignment group, and U chooses Unmerge Cells. On an English-language Windows installation, this is the quickest built-in keyboard route. It is a sequence of key presses rather than a single shortcut chord such as Ctrl+C.

Start by selecting a cell in the merged area, or select a range containing the merged cells you want to separate. Then press Alt, H, M, U in order. If the KeyTips shown on screen differ, follow the letters Excel displays: KeyTips can vary with the app version, language, or ribbon configuration. You can also use the mouse route, which is useful if you do not remember the sequence: open the Home tab, click the arrow beside Merge & Center, and choose Unmerge Cells.

If you merged the cells just now and have not made other changes you need to keep, Ctrl+Z will undo the merge operation. That is different from unmerging: Undo reverses the recent action, while Unmerge Cells changes the current merged range back into separate cells.

What Unmerge Cells changes

Unmerge Cells removes the merged-cell structure and restores the cells as individual grid cells. For example, if B2:D2 were merged, unmerging them makes B2, C2, and D2 separate cells again. Any value or formula retained by the merge remains in the upper-left cell, B2 in this example; the other cells are blank.

This is the key limitation to understand: unmerging does not bring back content that was discarded when the cells were originally merged. If B2, C2, and D2 each contained text before they were merged, Excel kept the upper-left entry and removed the other entries when the merge was made. Unmerge Cells cannot reconstruct those deleted values. You would need to recover them from Undo, a saved earlier workbook version, a backup, or another copy of the data.

The command changes the cell structure, not the meaning of the remaining entry. If the upper-left cell contains a formula, that formula remains there. Review the result after unmerging, particularly if the merged area was part of a report or a worksheet used by other people.

How to unmerge cells step by step

  1. Click any cell in the merged area. If you intend to unmerge several areas, select the range that contains those merged cells.
  2. Press Alt, H, M, U in sequence. Alternatively, open Home > Merge & Center and click Unmerge Cells.
  3. Check that the former merged area is now divided into separate cells and that its remaining value or formula is where you expect it.
  4. If the cells were merged only to center a heading, consider applying Center Across Selection or another alignment option instead of merging them again.

When you select a range that includes more than one merged area, the command can unmerge the merged cells in that selection. To avoid changing unrelated parts of a worksheet, select only the intended section. For a workbook you did not create, it is sensible to save a copy before making broad layout changes.

Excel for Mac and Excel for the web

The Alt, H, M, U KeyTip sequence described above is for Excel on Windows. Excel for Mac does not use that Windows ribbon sequence as its standard shortcut. On a Mac, select the merged cell, then use the Home tab’s Merge & Center menu and choose Unmerge Cells. If you have just merged the cells, Command+Z undoes that last action on a Mac, provided you have not made later changes you need to preserve.

In Excel for the web, use the Home tab’s Merge & Center menu and select Unmerge Cells. Windows desktop KeyTips may not be available in the same way in a browser, and browser shortcuts can be intercepted by the browser or operating system. The ribbon command is the dependable option across these platforms. The exact placement or appearance of the menu can vary slightly as Microsoft updates the interface.

Find merged cells before changing a worksheet

Merged cells can be hard to spot in a large sheet, and they can interfere with sorting, filtering, copying, and filling data. Excel’s Find dialog can search for cells with the merged format, which is useful before changing a worksheet or preparing data for analysis.

  1. Press Ctrl+F on Windows to open Find, then choose Options if the extra search settings are hidden.
  2. Choose Format, open the Alignment tab in the Find Format dialog, and select the Merge cells option.
  3. Choose Find All to list matching cells. Check the results before selecting or changing a large range.
  4. After searching, clear the Find Format criteria if you want later searches to ignore that formatting requirement.

The Find dialog searches according to the scope selected there, such as the current sheet or workbook. Finding merged cells does not itself change them. If you plan to unmerge results, review the selected areas carefully and make sure you understand which upper-left cells contain the values you need.

Common problems and how to fix them

  • The shortcut does nothing: Confirm that Excel has focus and press the keys one at a time: Alt, then H, then M, then U. If your ribbon shows different KeyTips, use those letters or choose the command with the mouse.
  • Unmerge Cells is unavailable: The current selection may not contain a merged cell. Click directly inside the merged area. Worksheet protection can also restrict formatting changes; if you are authorized to edit the sheet, check whether it needs to be unprotected first.
  • The text appears only in one cell afterward: That is expected when the original merge removed the other entries. The surviving content is in the upper-left cell; unmerge does not restore deleted content.
  • Sorting or filtering still behaves oddly: Check the full data range for other merged cells. Unmerging one visible heading does not remove merges elsewhere in the range. Excel tables do not support merged cells within the table, so avoid merging cells in a range you need to use as a table.
  • The layout changes after unmerging: Review alignment, borders, row height, and column widths. The cells become independent, so a heading that previously occupied one wide merged cell may no longer appear centered across the same space.

When to use an alternative to merging

Merging can make a heading look centered across several columns, but it changes the worksheet’s cell structure. That can make it harder to select individual cells, sort records, use filters, or paste a rectangular block of data. If the goal is only visual alignment, Excel offers an alternative that leaves the cells separate.

For a heading, select the cells across which it should appear, open the Format Cells dialog, choose the Alignment tab, and set Horizontal to Center Across Selection. You can open Format Cells from the Alignment group’s dialog launcher on the Home tab, or use Ctrl+1 on Windows. This centers the text across the selected cells without combining them into one merged cell. The text remains in the leftmost cell, so the other cells are still available for normal worksheet operations.

Center Across Selection is not identical to Merge & Center: it does not create one larger cell, and its alignment is horizontal. It is often a more practical choice for report headings above sortable data. For data-entry sheets, keep each record’s values in separate cells and use formatting, column widths, or a heading row rather than merging cells within the records.

Frequently Asked Questions

What is the exact keyboard shortcut to unmerge cells in Excel?

In Excel for Microsoft 365 on Windows, press Alt, H, M, U in sequence. It opens the Home tab’s Merge & Center menu and selects Unmerge Cells.

Does unmerging restore the values that were in every cell?

No. When cells are merged, Excel retains the upper-left entry and removes other entries in the merged range. Unmerging separates the cells but cannot recover those removed values.

Can I unmerge several cells at once?

Yes. Select a range containing the merged areas you want to change, then use the Unmerge Cells command. Check the selected range first so you do not alter merges elsewhere on the worksheet.

Is there a Mac shortcut for unmerging cells?

The Windows Alt, H, M, U sequence is not the standard Mac route. On a Mac, select the merged cell and choose Unmerge Cells from the Home tab’s Merge & Center menu.

Will unmerging change the formatting?

It restores separate cells, but the resulting layout may look different because the text is no longer in one merged area. Check alignment, borders, and row height afterward; adjust them if needed.

Bottom line

For Excel on Windows, the direct unmerge sequence is Alt, H, M, U. Use it on a selected merged cell or selected range, then check the result: only the upper-left cell’s retained content remains, and unmerging cannot recover other values lost when the merge was first created. If you only need a heading centered across columns, Center Across Selection can provide the look without merging the cells.

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.