Unmerge Cells in Excel: Keyboard Shortcuts and Steps

How-to basics · Updated November 20, 2026

To unmerge cells in Excel for Microsoft 365 on Windows, select a merged cell or merged range, then press Alt, H, M, U one key at a time. This opens the Home tab’s Merge & Center menu and chooses Unmerge Cells. The former cells become separate again, but Excel keeps the content only in the top-left cell of each merged area.

Unmerging is useful when you need to sort, filter, copy, or edit a worksheet whose layout contains merged cells. Before you start, note that unmerging does not recover values that were discarded when cells were originally merged. If the merged cell contains important information, make a copy of the workbook or record the value first.

What You’ll Need

  • Excel for Microsoft 365 on a Windows computer. The steps also generally apply to recent desktop versions of Excel for Windows.
  • The worksheet containing the merged cells, with permission to edit it. If the sheet is protected, you may need its password or permission to unprotect it first.
  • The address of the merged cell or range if you want to select it without using a mouse. For example, if B2:D2 is merged, use B2, the top-left cell.
  • An optional backup or duplicate worksheet if the existing layout or content is important.

Step-by-Step

  1. Open the correct worksheet. In the workbook, move to the sheet that contains the merged cells. If the sheet has many tabs, use Ctrl+Page Up or Ctrl+Page Down on Windows to move between worksheets. Check the sheet name before changing anything.
  2. Select the merged cell or range with the keyboard. If you know the address, press Ctrl+G to open Go To, type the top-left address of the merged area, such as B2, and press Enter. For a merged range such as B2:D2, entering B2 selects that merged cell. To target several merged areas, enter a range that includes them, such as B2:F10. You can also use the arrow keys to move the active selection onto a merged cell, although the selection may jump over the full width or height of the merged area.
  3. Check that your selection includes the intended merge. Look at the Name Box, to the left of the formula bar, to confirm the active address. If you used Go To, make sure you typed the correct sheet and cell reference. When you want to change just one merged area, select that area rather than a large block of unrelated cells.
  4. Open the Merge & Center menu with key tips. Press and release Alt, then press H, then M. Do not hold the keys down together as if they were a three-key shortcut. The letters are ribbon key tips: Alt opens key tips, H points to Home, and M opens the merge options.
  5. Choose Unmerge Cells. Press U. Excel removes the merge from the selected merged cell or cells. The keyboard sequence is Alt, H, M, U, pressed in order. If you prefer to use the ribbon, select Home > Merge & Center arrow > Unmerge Cells.
  6. Check the result and content. The cells in the former merged area should now be separate. Excel retains the value or text in the top-left cell and leaves the other cells blank. For example, unmerging B2:D2 keeps the content in B2; C2 and D2 are empty unless they already had content, which could not normally coexist with a standard merged cell.
  7. Repeat for other areas if needed. Select another merged cell or a range containing additional merged cells, then repeat the same key sequence. If you select a larger range, review it before pressing the final U so you do not alter merges outside the area you meant to fix.

If you want to remove every merge from a worksheet, first save a backup. In the worksheet, press Ctrl+A to select the current data region, then press it again to select the whole sheet in typical worksheet contexts. Use Alt, H, M, U. Because selection behavior can depend on where the active cell is and whether a table is selected, confirm that the entire sheet is highlighted before unmerging all of it. This changes formatting throughout the worksheet, so use it only when that is what you intend.

In Excel for Mac, the Windows Alt key-tip sequence does not apply. You can use the keyboard to move focus among Excel areas with Control+F6, then use Tab and the arrow keys to navigate the ribbon controls; choose Home, Merge & Center, and Unmerge Cells. The exact number of focus changes can vary with the ribbon layout. If keyboard navigation is inconvenient, the direct Mac ribbon path is Home > Merge & Center > Unmerge Cells. Excel for the web also uses a different keyboard and ribbon environment, so do not assume the Windows key-tip sequence will work there.

Common Mistakes

  • Holding Alt and typing the letters as one shortcut. The Windows key-tip sequence is entered in stages: press and release Alt, then H, then M, then U. If you hold Alt while typing, Excel may interpret the keys differently or the sequence may not advance.
  • Selecting the wrong cell. A merged area can look like one large cell, and its content is associated with its top-left cell. Use Go To with that top-left address, or check the highlighted selection before choosing Unmerge Cells.
  • Expecting Excel to restore old values to every cell. Unmerge only separates the cells; it does not recreate text or numbers that were removed during the original merge. If you need repeated labels in every resulting cell, enter or fill those values separately after unmerging.
  • Unmerging the whole worksheet by accident. Selecting the entire sheet and using the command removes all merges on that sheet, including title formatting and layout merges far from the active area. Make a copy first and verify the selection is as large or as small as intended.
  • Assuming the worksheet is protected or the workbook is broken. A disabled command may simply mean the sheet is protected or the current selection does not contain a merged cell. Check the selection and protection status before repeating the sequence.
  • Confusing Unmerge Cells with Merge Across or Merge & Center. Those are separate choices in the same menu and can change the layout in different ways. Read the menu choice shown on screen before confirming it.

Tips

  • Use a small test area first. If you are unfamiliar with the ribbon key tips, select one unimportant merged cell and try the sequence. Once you see how the selection and result behave, continue with the rest of the worksheet.
  • Keep a copy before bulk changes. Save a separate workbook copy or duplicate the sheet before unmerging a large range. That gives you a straightforward way to compare the original layout or recover it if you change more than intended.
  • Check the formula bar before unmerging valuable content. When a merged cell is selected, the formula bar shows the stored value or formula. This is a quick way to confirm what will remain in the top-left cell.
  • Unmerge before sorting or filtering. Merged cells can interfere with common data operations, especially when a merge spans rows or columns in a list. Separate the cells and review the layout before applying a sort or filter.
  • Use the ribbon path if key tips differ. If an Excel update, language setting, or customized ribbon means Alt, H, M, U does not reach the command, open Home > Merge & Center arrow and choose Unmerge Cells. The visible command is a reliable way to verify the intended action.
  • Do not expect unmerging to erase borders or alignment. The cells become separate, but formatting such as borders, fills, and alignment may remain. If the result looks uneven, adjust formatting separately rather than repeating the unmerge command.

Troubleshooting

The shortcut does nothing. Make sure Excel has focus, then press and release each key in sequence. If a laptop’s function-key settings or another application intercepts Alt, use the ribbon path: Home > Merge & Center arrow > Unmerge Cells. Also check that the workbook is not in a mode that prevents editing.

Unmerge Cells is unavailable or dimmed. Select a cell that is actually part of a merged area, or select a range containing one. If the worksheet is protected, use Review > Unprotect Sheet if you are authorized and know any required password. A protected workbook structure is a different restriction from a protected sheet; check the relevant protection settings rather than repeatedly pressing the shortcut.

The wrong cells were unmerged. If you have not made other changes since the command, press Ctrl+Z to undo it. Then select the intended merged cell or smaller range and try again. If further edits have occurred, undoing may also reverse those edits, so review Excel’s undo sequence before proceeding. A saved backup is the safer recovery option for extensive changes.

The text appears in only one cell afterward. That is expected: Excel keeps the content from the top-left cell of a merged area. If the same label should appear in every newly separate cell, copy or fill it into the other cells after unmerging. If the missing information existed before the cells were merged, look for an earlier workbook version or backup; unmerging cannot retrieve discarded content.

The worksheet still will not sort or filter properly. Look for other merged areas elsewhere in the affected data range, not just the one you first changed. Repeat the selection and unmerge process where needed. Also check for blank headers, inconsistent data, or other layout issues, since unmerging may not be the only cause of a sorting or filtering problem.

Frequently Asked Questions

What is the keyboard shortcut to unmerge cells in Excel?
In Excel for Microsoft 365 on Windows, select the merged cell or range and press Alt, H, M, U in sequence. It is a ribbon key-tip sequence rather than keys that must all be held down together.

Can I unmerge cells without a mouse?
Yes. Press Ctrl+G, enter the top-left address of the merged cell, and press Enter. Then use Alt, H, M, U. You can also move the active cell with the arrow keys before opening the menu.

Does unmerging restore the contents of all the original cells?
No. A normal merge retains the content from the top-left cell and removes other cell contents. Unmerging makes the cells separate but does not restore deleted values. Retrieve missing information from a backup or an earlier workbook version if one is available.

Will unmerging change the appearance of my worksheet?
It changes the cell structure and can affect how text is positioned or displayed. Existing formatting such as borders, fills, and alignment may remain, so inspect the result and adjust formatting if necessary.

Can I unmerge every merged cell on a sheet at once?
Yes. Select the entire worksheet, then run the Unmerge Cells command. On Windows, Ctrl+A twice usually selects the sheet when starting in a worksheet cell. Verify the selection first and save a copy, because this removes all merges on that sheet, including layout merges outside your data.

Does Alt, H, M, U work in Excel for Mac?
No. That key-tip sequence is for Excel on Windows. On a Mac, navigate the ribbon with the Mac keyboard controls or use Home > Merge & Center > Unmerge Cells. Excel for the web also has a different keyboard environment.

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.