In Excel for Microsoft 365 on Windows, select the merged cell or range, then press Alt, H, M, U in sequence to unmerge it. This ribbon Key Tip sequence opens the Home tab’s Merge & Center menu and chooses Unmerge Cells; it is not a four-key combination to hold down at once.
The Windows shortcut and what each key does
The sequence works through Excel’s ribbon access keys. Press Alt to show Key Tips, H to select Home, M to open the Merge & Center menu, and U to choose Unmerge Cells. Press the keys one after another, watching the on-screen letters if you want to confirm the next choice. If your Excel installation displays different Key Tips because of language or interface differences, follow the letters shown on screen rather than assuming the English sequence will match.
Before using the sequence, click a merged cell or select a range that includes the merged cells you want to split. You do not need to select each constituent cell separately; a merged block behaves as one cell until it is unmerged. For example, if B2:D2 is merged, selecting anywhere in that block and choosing Unmerge Cells separates it into B2, C2, and D2 again.
- Shortcut: Alt, H, M, U, pressed in order.
- Ribbon route: Home > Merge & Center arrow > Unmerge Cells.
- Undo: Ctrl+Z reverses the unmerge if it is the most recent action.
Use the ribbon if you prefer not to memorize keys
The mouse or ribbon route performs the same command and is often easier when you are unfamiliar with Key Tips. Select the merged cells, open the Home tab, and click the arrow beside Merge & Center in the Alignment group. Choose Unmerge Cells from the menu. The exact control may appear as a compact button on a narrow ribbon, so expanding the ribbon or widening the Excel window can make the dropdown easier to locate.
If you click the main Merge & Center button rather than its dropdown, Excel may apply the button’s current merge behavior instead of showing the option you want. Use the arrow to see the menu choices. When the selected cells are merged, the menu includes an unmerge command. The ribbon route is also useful when Key Tips are unavailable, when you are using a localized version of Excel, or when you want to verify the command name before applying it.
What unmerging changes—and what it does not
Unmerging restores the cells as separate grid cells. If B2:D2 was one merged cell, after unmerging there are three cells again, but Excel does not distribute the former value among them. The content that remained in the merged cell stays in the upper-left cell, B2 in this example; C2 and D2 are blank. Unmerge is a structural change to the layout, not a command to recover earlier contents or automatically fill the newly separated cells.
This distinction matters because merging cells can discard other values. If you merge a range that contains content in more than its upper-left cell, Excel warns that merging keeps only the upper-left value and removes the other contents. Once that merge has been completed and the action is no longer available to undo, unmerging cannot bring the discarded values back. If the missing entries matter, check a backup, version history, or another copy of the workbook.
Unmerging also does not promise to restore every prior formatting choice. The cells become independent, but their displayed appearance can depend on the formatting already applied to the range, such as borders, fill, alignment, and number format. Inspect the result, especially if the merged cell was used as a heading or title, and adjust formatting as needed.
Unmerge several cells or a larger range
You can select a larger area and use the same command to unmerge merged cells within it. This is useful when a worksheet has several merged headings in a table or report. To avoid changing unrelated areas, select only the relevant rows, columns, or block of cells. If the sheet contains a mixture of merged and ordinary cells, check the selection before you act and confirm the result afterward; selecting the full merged blocks makes the intended scope clear.
For a workbook with many worksheets, unmerging one sheet does not automatically unmerge the same addresses on the other sheets. Repeat the operation on each relevant sheet. You can group worksheets to make some edits across multiple sheets, but grouped editing affects every selected sheet and can be easy to overlook. For a one-time cleanup, working sheet by sheet is usually safer, particularly when the layouts differ.
After unmerging, check formulas and references that relied on the former merged layout. A formula referring to the upper-left cell usually still refers to that address, but labels and values may now look visually separated from the data they describe. Sorting, filtering, selecting, and copying a rectangular table are generally easier when the table does not contain merged cells, so use the change as a chance to check the sheet’s structure rather than only its appearance.
Common reasons the shortcut seems not to work
The most common issue is using the keys as though they were pressed simultaneously. They are sequential Key Tips: press Alt, release it, then press H, M, and U in order. If Excel shows a different Key Tip after any step, follow that prompt. A keyboard layout, localized Office installation, or a changed ribbon can affect what appears, so the visible prompts are the useful guide.
Another possibility is that the active selection does not contain a merged cell. If you select ordinary cells, Unmerge Cells may not be available or the command will have no visible effect. Click the suspected merged area and check whether the selection spans multiple rows or columns in the grid. You can also open the Merge & Center menu and inspect whether Unmerge Cells is offered for the current selection.
- Nothing changes: Confirm the active worksheet and selection, then check that the selected area actually contains merged cells.
- The wrong cells change: Undo immediately with Ctrl+Z and select the intended merged block more carefully.
- Content appears missing: Remember that unmerging cannot restore values discarded when the cells were originally merged.
- The alignment looks different: Reapply the desired alignment or other formatting after unmerging.
Mac and Excel for the web
The Alt, H, M, U Key Tip sequence is for Excel on Windows and should not be presented as the Mac shortcut. In Excel for Mac, select the merged cell or range and use the Home tab’s Merge & Center dropdown, then choose Unmerge Cells. Ribbon layout can vary with window size and version, but the command is in the merge menu. If you use Excel on a Mac and need keyboard access, consult the shortcut help for your installed Excel version rather than substituting the Windows Key Tips.
In Excel for the web, select the merged cells and use the Home tab’s Merge & Center menu to choose Unmerge Cells. The browser version’s interface can differ slightly from the Windows desktop ribbon, and browser keyboard shortcuts may be intercepted by the browser or operating system. The menu is the clearest route if the desktop sequence does not behave as expected. In all versions, check the selection and confirm the unmerged cells before continuing with a large edit.
When to unmerge—and a cleaner alternative
Unmerge cells when the merged layout is obstructing editing, sorting, copying, or table maintenance, or when you need each row and column to hold its own value. Merged cells can make rectangular data harder to manage because one cell spans multiple positions in the grid. A merged title above a report may be harmless, but merging cells inside the data area can complicate routine work such as sorting records or pasting a block of values.
If your goal is simply to center a heading across several columns, consider Center Across Selection instead of merging. Select the cells, open the Format Cells dialog from the Alignment group’s dialog launcher, choose the Alignment tab, and set Horizontal to Center Across Selection. The cells remain separate, so the heading can appear centered without combining the cells into one. This option is especially useful for worksheet titles above a table; it is not a substitute for unmerging existing cells until you have checked the layout and contents.
For a table heading that needs to cover several columns, another practical approach is to place the heading in one cell and use alignment and column widths to make it readable, rather than merging cells within the table. Keep labels and records in a regular grid wherever possible. This makes later sorting, filtering, and copying more predictable and reduces the need to repair the layout during analysis.
Frequently Asked Questions
What is the unmerge shortcut in Excel for Windows?
Press Alt, H, M, U in sequence after selecting the merged cell or range. It is a series of ribbon Key Tips, not keys held down together.
Does unmerging restore text that was deleted when cells were merged?
No. Unmerge separates the cells but keeps the surviving value in the upper-left cell. Values discarded during the original merge must be recovered from undo history, a backup, version history, or another source.
Will unmerging fill the newly separate cells with the same value?
No. The original value remains in the upper-left cell, and the other cells are blank unless they already contain content for some reason. Copy or fill the value into other cells only if that is what the worksheet requires.
Can I unmerge every merged cell in a worksheet at once?
Select the relevant worksheet range, or the whole sheet if that is genuinely what you intend, and choose Unmerge Cells. Review the result carefully: this changes layout across the selection, and it will not recover any content that was discarded earlier.
Is there a Mac shortcut for Alt, H, M, U?
No; that sequence is for Windows Excel. On Mac, use Home > Merge & Center > Unmerge Cells. In Excel for the web, use the corresponding Home tab menu if the Windows sequence is unavailable.
Why can’t I find Unmerge Cells?
It may not be available because the current selection does not contain a merged cell, or the Merge & Center control is collapsed on the ribbon. Select the suspected merged area and open the dropdown arrow beside the merge button.
Related
- Excel Randomize List of Names: 10 Reliable Methods
- Excel Quote Template With Drop-Down Lists That Work
- Excel Quick Access Toolbar: Add Paste Values Easily
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Move the Quick Access Toolbar in Excel (Windows)In Excel for Microsoft 365 on Windows, click the Quick Access Toolbar’s small customization arrow and choose Show…
- Power Query Data Transformation in Excel: A Practical GuidePower Query data transformation is the process of importing data into Excel, cleaning and reshaping it in the…
- How to Add a Checkbox in Google Sheets on Android or iPhoneTo add checkboxes in the Google Sheets mobile app, select the cell or range, tap the three-dot More…
- Excel Dropdown Lists: How to Create and Manage ThemYes, Excel has dropdown lists. In Microsoft Excel for Microsoft 365 on Windows, you can create one with…
- Project Tracker Spreadsheet in Google Sheets: Setup GuideYes. You can make a project tracker spreadsheet in Google Sheets by creating a sheet with one row…
- Conditional Formatting in Excel: Questions AnsweredIn Excel for Microsoft 365 on Windows, select the cells you want to format, then choose Home >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.