In Excel for Microsoft 365 on Windows, select a merged cell and press Alt, H, M, then U—one key after another, not all at once. This runs Home > Merge & Center > Unmerge Cells. Excel separates the cells in the merged range, but keeps the existing contents in the range’s top-left cell only. Check that you know where the value or formula is before unmerging if the surrounding cells contain information you need.
What You’ll Need
- A workbook open in the desktop version of Excel for Microsoft 365 on Windows.
- A worksheet with at least one merged cell. If you are unsure, click the cell and look at Home > Merge & Center; the command or its highlighted state can indicate that the selection is merged.
- Permission to edit the worksheet. A protected sheet may prevent changes to merged cells until it is unprotected.
You do not need to install an add-in or enable a special setting. Save the workbook first if the layout is important, or use Undo immediately if the result is not what you intended.
Step-by-Step
- Find the merged cell. Click the cell that appears to span more than one row or column. Excel treats a merged range as one selectable cell, so clicking anywhere inside it generally selects the whole merged area. If the merged cell is hard to spot, click likely candidates and check the Merge & Center control on the Home tab. You can also use Find to locate a distinctive value, then inspect the cell it finds.
- Check which value will remain. Before changing the layout, note that Excel normally stores the content of a merged range in its top-left cell. Unmerging does not copy that content into every newly separated cell. For example, if B2:D2 is merged and contains a heading, after unmerging the heading remains in B2; C2 and D2 are empty. If you need the heading elsewhere, copy it first or record it so you can restore it after the operation.
- Keep the merged cell selected. If you clicked inside the merged range, proceed with that selection. If you want to unmerge several areas, select the cells or range that includes them. Avoid selecting a large section unnecessarily: a broad selection can affect every merged range inside it, not just the one you were looking at. To undo only one merge, select that merged area alone.
- Press the Windows key sequence. Tap and release Alt. When Excel displays ribbon Key Tips, press H for Home, then M for Merge & Center, then U for Unmerge Cells. Do not hold down Alt while typing the letters. The full sequence is often written as Alt+H, M, U, but the commas mean that each key is pressed in order.
- Confirm that the merge is gone. The cells that made up the merged range should now be individually selectable. Click one of the cells that was formerly inside the range and check that the selection border covers only that cell. The original value or formula should remain in the former top-left cell, while the other cells in the area are usually blank.
- Review the worksheet layout. Unmerging may change how a heading appears, because it no longer spans the full width of the former merged range. Adjust column widths, alignment, or text wrapping if needed. If you need the content to look centered across columns without merging, consider the Center Across Selection alignment option instead of merging cells again.
- Save or undo. If the result is correct, save the workbook. If you unmerged the wrong area or did not mean to change the layout, press Ctrl+Z on Windows immediately. Undo restores the previous merge in most normal cases, but later edits may need to be undone as well, so check the worksheet before continuing.
You can also use the mouse if you prefer: select the merged cell, open Home > Merge & Center using its dropdown arrow, and choose Unmerge Cells. The keyboard sequence reaches the same command and is useful when you want to avoid navigating the ribbon.
Common Mistakes
- Pressing the keys as a simultaneous shortcut. This is a ribbon Key Tip sequence, not a combination to hold down. Tap Alt, release it, then type H, M, and U in order. If you hold Alt while pressing the letters, Excel may not follow the intended path.
- Expecting the value to fill every cell. Unmerge separates the cells; it does not duplicate the former merged cell’s content across the new cells. Copy the value first if you will need it in more than one place.
- Selecting an entire worksheet or a much larger range than necessary. If that selection contains several merged areas, the command can unmerge more than the one you meant to change. Select the specific merged cell or the smallest useful range.
- Confusing unmerge with undo. Unmerge is a layout change, not a way to restore deleted data. If the cell contents were cleared or overwritten before you unmerged, use Undo or recover a previous workbook version rather than expecting unmerge to bring them back.
- Assuming a cell is merged because its text crosses column lines. Text can visually overflow into empty neighboring cells without being merged. Click the cell and inspect the Merge & Center control before using the sequence; unmerging an ordinary cell will not change its merge status.
Tips
- Use the on-screen Key Tips as a guide. Excel shows letters or labels for ribbon commands after you press Alt. In a standard English Windows installation, the path is Alt, H, M, U. If a label differs on your screen, follow the displayed labels rather than repeatedly trying a sequence that does not match your Excel setup.
- Unmerge several cells deliberately. If you select a range that contains multiple merged areas and run Unmerge Cells, Excel can unmerge the merged cells within that selection. First inspect the range so you do not alter headings or form layouts you intended to keep merged.
- Plan for sorting and filtering. Merged cells can make sorting, filtering, and copying table data difficult. Unmerging is often a useful first step when preparing a range for those tasks, but check the resulting blank cells. You may need to fill appropriate labels down the rows before treating the range as a regular data table.
- Use Center Across Selection for appearance-only layouts. If the goal is to center a heading over several columns, select the cells and open the Format Cells dialog with Ctrl+1. On the Alignment tab, choose Center Across Selection in the Horizontal list. This keeps the cells separate, which can make later sorting and editing easier.
- Remember platform differences. On Excel for Mac, use Home > Merge & Center > Unmerge Cells; the Windows Alt-based Key Tip sequence does not apply in the same way. In Excel for the web, use the Home ribbon command if available. Keyboard access keys can vary by browser, language, and ribbon layout, so use the visible command when the Windows sequence is not recognized.
Troubleshooting
The shortcut does nothing. Make sure Excel, rather than another app or a dialog box, has focus. Tap and release Alt, watch for Key Tips on the ribbon, and then press the letters one at a time. If Key Tips do not appear or the letters shown are different, use the ribbon path Home > Merge & Center > Unmerge Cells. Shortcuts may differ with a non-English Excel display language or a customized ribbon.
Unmerge Cells is unavailable or appears disabled. Click directly inside the suspected merged cell and check again. If the worksheet is protected, go to Review > Unprotect Sheet if you have permission and the required password. If the cell is part of a table or a restricted range, review the worksheet’s structure and permissions before making changes. A disabled command can also mean the selected cell is not merged.
The result looks unchanged. Check whether the cell was actually merged. A value that extends visually over empty cells is not necessarily a merged value. Also inspect the selection border after the command: if it covers only one cell, the area may already have been unmerged. If the text still looks centered, the cells may have centered alignment applied separately.
Several cells became unmerged unexpectedly. Press Ctrl+Z right away to reverse the command. Then select only the intended merged cell and repeat the operation. If you have made many further edits since the unmerge, review the Undo list carefully or restore a saved copy rather than risking unrelated work.
You cannot find the original content in the other cells. That is expected: Excel retains the merged range’s content in its top-left cell and leaves the other cells empty. If the value is missing even from that cell, try Undo, check whether another edit replaced it, or restore an earlier version from your saved file or cloud version history.
Frequently Asked Questions
What is the shortcut key to unmerge cells in Excel?
In Excel for Microsoft 365 on Windows, press Alt, then H, M, and U in sequence. This opens the Home ribbon command for Unmerge Cells. It is a Key Tip sequence, not a single Ctrl-based shortcut.
Does unmerging put the original value in every cell?
No. The content remains in the top-left cell of the former merged range. The other cells are generally empty. Copy the content first if you need to repeat it in the newly separated cells.
Can I unmerge multiple merged cells at once?
Yes. Select a range containing the merged areas, then run the Unmerge Cells command. Excel unmerges the merged cells in that selection. Check the selection first, because this can affect multiple headings or layout areas at once.
Is there a direct unmerge shortcut on Mac?
The Windows Alt, H, M, U sequence is not the Mac equivalent. On Excel for Mac, use Home > Merge & Center > Unmerge Cells. Ribbon access keys can differ by version and setup, so the visible command is the dependable route.
Can I undo an unmerge?
Yes. Press Ctrl+Z on Windows immediately after unmerging. On Mac, use Command+Z. Undo is safest before making additional edits, and it restores the prior merged layout rather than distributing the content.
Related
- How to Select Cells in Excel Using Keyboard Shortcuts
- Select in Excel Without Dragging: Keyboard and Name Box
- Select Full Columns in Excel With a Keyboard Shortcut
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Protect Sheet Shortcut: Windows Steps and OptionsIn Excel for Microsoft 365 on Windows, press Alt, then H, O, and P in sequence to open…
- How to Clear Cache in MS Outlook Without Losing MailTo clear Outlook’s local mailbox cache in classic Outlook for Windows, close Outlook, rename its Exchange or Microsoft…
- How to Make a Box Plot in ExcelIn Excel for Microsoft 365 on Windows, select your data with a heading for each group, then choose…
- Freeze and Unfreeze Panes in Excel: A Step-by-Step GuideTo keep headings or identifying columns visible while you scroll in Excel, select the cell just below the…
- How to Change Email View in Outlook 365: Layouts and PanesTo change the email view in Outlook 365, use View > Change View in classic Outlook for Windows…
- Excel Cell Text Overflow: Causes and FixesIn Excel for Microsoft 365 on Windows, text in a cell can display across neighboring cells when they…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.