In Excel for Microsoft 365 on Windows, select a merged cell and press Alt, H, M, U, one key after another, to unmerge it. You can also use Home > Merge & Center ▼ > Unmerge Cells; unmerging restores the separate cells but does not bring back any content that was discarded when they were merged.
What the unmerge shortcut does
The key sequence is a set of ribbon access keys, not a four-key combination: press and release Alt, then H, then M, then U. H opens the Home tab’s key tips, M opens the Merge & Center menu, and U chooses Unmerge Cells. If a menu or key tip does not appear as expected, press Esc and start again, making sure Excel is the active window.
Unmerge Cells reverses the cell layout, not the editing history. For example, if B2:D2 is one merged cell, unmerging separates B2, C2, and D2. Any value still in the merged cell remains in B2, the upper-left cell of that range; C2 and D2 are blank. The action does not redistribute the text across the three cells.
The command affects the merged range that contains the selected cell. You do not need to select every cell in that range first. If several merged ranges are included in a selection, Excel can unmerge them together, although a selection that cuts through a merged range may be awkward to create. Select the whole relevant area or work on each merged range separately if the selection behaves unexpectedly.
Unmerge cells with the ribbon
If you would rather use the mouse, or the keyboard sequence is unavailable, the ribbon command is straightforward. In Excel for Microsoft 365 on Windows:
- Click a cell in the merged range. To handle several ranges, select the area that contains them.
- Open the Home tab.
- Open the arrow beside Merge & Center in the Alignment group.
- Choose Unmerge Cells.
The button’s main face may show Merge & Center or another merge option depending on the selection. Use the small dropdown arrow to see the available choices. The unmerge command is also available from the Alignment tab of the Format Cells dialog: select the cells, press Ctrl+1, open Alignment, clear the Merge cells checkbox, and select OK. This can be useful when you are already adjusting alignment settings.
What happens to data and formatting
When cells are merged, Excel keeps the value in the upper-left cell of the merged area and removes values from the other cells in that area. If A1:C1 each held a different label before they were merged, only the value from A1 remains after the merge. Unmerging later gives you three cells again, but it cannot reconstruct the former contents of B1 and C1.
That limitation is important when a workbook contains information rather than just a heading. If the merge was made moments ago, Undo (Ctrl+Z on Windows) may reverse the merge and restore the earlier cell values, provided no intervening actions have made that undo unavailable. Unmerge itself is not a recovery command. For an older workbook, check a backup, version history, or another copy before assuming the cleared values can be recovered.
Unmerging does not necessarily remove all formatting. Existing borders, fills, fonts, number formats, and alignment may remain on individual cells, depending on how the range was formatted. After separating cells, inspect the range for unwanted borders or inconsistent alignment. If the text appears to have vanished, check the upper-left cell and the formula bar; the other cells being blank is normal when they were part of a merged range.
Unmerge many cells or a whole worksheet
To unmerge several areas at once, select a range that includes the merged cells and choose Unmerge Cells. You can also select the entire worksheet by clicking the small triangle where the row numbers and column letters meet, then use the Home-tab command. This is often faster than searching a large sheet for every merged heading.
Use a whole-sheet operation carefully. It can affect layout in places you did not intend to change, such as report titles, printed forms, or instructional notes. A practical approach is to save a copy first, select the relevant region rather than the entire sheet when possible, and inspect the result before continuing. If you need to locate merges before changing them, the Find command’s options can search for cells with particular formatting, but a format-based search may require setting a sample format and checking the matches individually.
Worksheets containing merged cells can also make some selection and editing tasks inconvenient. If a command reports that it cannot be used on part of a merged cell, select the full merged range or unmerge it first. Avoid selecting only one of the cells that would be inside the range after unmerging; while merged, Excel treats the area as a single cell for many operations.
Common problems and practical fixes
- The shortcut seems to type letters or does nothing: Confirm that Excel has focus, then press Alt, H, M, U in sequence rather than holding the keys together. If the key tips differ in your installation, use the ribbon dropdown instead.
- Unmerge Cells is unavailable or has no visible effect: Check that the selection actually includes a merged cell. The command does not change ordinary, separate cells.
- The text is still in only one cell: That is expected. Unmerge restores the cells, but Excel does not copy the surviving value into every cell.
- The sheet looks misaligned afterward: Adjust column widths, row heights, borders, and horizontal alignment. The original merged layout may have hidden the fact that neighboring columns were narrow.
- A filter, sort, or paste operation is blocked: Merged cells can interfere with operations that expect a regular grid. Unmerge the relevant area, make sure each row follows the same column structure, then retry.
If the shortcut sequence is not recognized, it may also be because another application or a customized keyboard setting intercepts a key. The ribbon path remains a reliable way to reach the same command. If you are working in a protected sheet, editing may be restricted; unprotect it only if you have permission and the required password or workbook access.
Use a safer alternative for centered headings
Merging is often used to center a title over several columns, but it can make sorting, filtering, selecting, and copying data harder. For a heading across columns A through D, a safer option is often Center Across Selection. Enter the heading in A1, select A1:D1, press Ctrl+1, open the Alignment tab, choose Center Across Selection in the Horizontal list, and select OK. The cells remain separate, and the text is centered across the selection.
This setting is an alignment choice, not a merge: the heading’s value remains in A1, while B1:D1 stay independent cells. That makes the layout less disruptive to many worksheet operations. It is not identical in every respect to a merged cell—for example, the text is still stored in just one cell—so check the display and print preview if the sheet is a formal report.
Other options may suit the layout better. Widen the first column, wrap the heading, or place the title in a text box if it must sit above a table without changing the table’s cell structure. For data tables, keep one value per cell and use formatting rather than merges wherever possible. This makes the worksheet easier to sort, filter, analyze, and reuse.
Excel on Mac and Excel for the web
The Alt, H, M, U sequence is for Excel on Windows. Excel for Mac uses a different keyboard and ribbon environment, and there is not a universal Mac equivalent to that Windows key-tip sequence. On a Mac, select the merged cell and use Home > Merge & Center dropdown > Unmerge Cells. The exact ribbon presentation can vary with the window size and Excel version.
Excel for the web also provides merge controls on the Home tab. If you are using a browser, the Windows desktop access-key sequence may not work as it does in the desktop app because browser shortcuts and web accessibility behavior can intervene. Use the ribbon command in the web interface instead, and check that the workbook is editable rather than opened in view-only mode.
Frequently Asked Questions
What is the unmerge shortcut in Excel?
In Excel for Microsoft 365 on Windows, press Alt, H, M, U sequentially. You can also choose Home > Merge & Center dropdown > Unmerge Cells.
Does unmerging restore the data in every cell?
No. The merge retains the upper-left cell’s value and removes values from the other cells in the merged range. Unmerge separates the cells but does not restore those removed values. Undo may help immediately after merging if the action is still available.
Can I unmerge all cells in a worksheet at once?
Yes. Select the whole sheet using the triangle at the top-left of the grid, then choose Unmerge Cells from the Home tab’s Merge & Center dropdown. Review the sheet afterward, because this changes every merged area, including headings and form layouts.
Why is the Unmerge Cells command greyed out?
The selected area may not contain a merged cell, or the worksheet may be protected against editing. Select a cell in a merged range and check the sheet’s protection status. Do not remove protection unless you are authorized to edit the workbook.
How do I center text across columns without merging cells?
Enter the text in the leftmost cell of the intended span, select the span, and use Ctrl+1 > Alignment > Horizontal > Center Across Selection. This centers the display while leaving the cells separate.
Related
- Excel Strikethrough Shortcut: Quick Key and How to Use It
- Subscript in Excel: Shortcut and Formatting Steps
- Quick Forecast in Excel: Steps, Limits, and Practical Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- IFERROR in Google Sheets: Meaning and How to Use ItIn Google Sheets, IFERROR checks whether a formula produces an error and lets you show a different value…
- Excel Power Query: Keep Column Headers When RefreshingYes—Excel Power Query keeps headers on refresh when they are defined as the query’s column names, usually by…
- How to Add Page Numbers to Different Sections in WordTo add page numbers to sections in Word, insert a section break where the numbering or layout should…
- Open a DB File in Excel: Methods, Limits, and OptionsYou usually cannot open a file ending in .db directly in Excel: the extension does not identify a…
- How to Archive All Emails in Your Outlook Inbox at OnceTo archive everything in your Outlook Inbox, open the Inbox, select all its messages, and choose Archive. Outlook…
- Freeze Panes in Excel Online: Keep Rows and ColumnsTo freeze panes in Excel Online, select the cell just below the row or rows and just to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.