Yes. In Excel for Microsoft 365 on Windows, select the merged cell or cells, then choose Home > Merge & Center > Unmerge Cells. Excel restores the cells in the merged area, but it does not bring back values that were discarded when the cells were originally merged.
What unmerging cells actually does
A merged cell is one displayed cell formed from two or more adjacent cells. For example, merging A1, B1, and C1 makes the range A1:C1 behave as a single, wider cell. The merged area is still based on those original worksheet cells, but Excel treats it as one unit for entering and displaying content.
Unmerging reverses that layout: A1, B1, and C1 become separate cells again. The cell at the upper-left corner of the former merged range, A1 in this example, is the anchor cell. It keeps the value or formula that was in the merged cell. The other cells are blank unless they already contain something that was not removed by the merge.
Unmerge changes the cell structure; it is not a command to split text into pieces or redistribute a heading. If a merged heading reads Quarterly Sales, unmerging does not put Quarterly in one cell and Sales in another. The full text stays in the upper-left cell, and the neighboring cells are empty.
How to unmerge cells in Excel for Windows
Use the ribbon to unmerge a cell in Excel for Microsoft 365 on Windows:
- Click a cell in the merged area. To unmerge several areas at once, select a range that includes them.
- Open the Home tab.
- In the Alignment group, open the Merge & Center dropdown.
- Choose Unmerge Cells.
The button may show Merge & Center rather than Unmerge Cells on the ribbon itself. Open its dropdown to see the unmerge command. You can also use the Windows ribbon key sequence Alt, H, M, U: press the keys in order rather than all at once. Ribbon key tips can vary slightly between Excel releases, so use the visible dropdown if the sequence does not match your installation.
Afterward, click one of the cells that used to be part of the merged area to inspect its contents. If the selection included multiple merged ranges, check each one: unmerging restores the cells in those areas, while any text that survived remains in the upper-left cell of its own range.
What happens to data and formatting
The most important limitation is that unmerging cannot recover content that was removed during the original merge. If A1 contained a title and B1 contained a date before A1:B1 was merged, Excel keeps the upper-left value, A1. The value in B1 is discarded when the merge is performed. Unmerging later leaves B1 blank; it does not restore the date.
Excel normally displays a warning when a merge would discard content from other cells, but the warning is easy to overlook. If you have just merged cells and realize the result is wrong, use Undo immediately (Ctrl+Z on Windows) rather than unmerging. Undo can reverse the merge operation and restore the earlier cell contents while it remains in the undo history. If the workbook has since been closed or the undo history is no longer available, check a saved copy, a backup, or version history where available.
Formatting is separate from the cell values. Unmerging does not usually erase the formatting of the area, but the cells may not look exactly as expected afterward. Check alignment, borders, fill color, and text wrapping. The retained value may still be centered or may spill visually into neighboring blank cells, depending on its alignment and the widths of those cells. A border around the former merged area can also make the restored cells appear as one box even though they are now separate.
Unmerging a selection with several cells
You do not have to unmerge ranges one at a time. Select a larger block containing multiple merged areas, then choose Unmerge Cells. Excel unmerges the merged areas in the selection. This can help when a worksheet has many merged headings, but inspect the result afterward, especially if the selection also contains ordinary cells or differently sized merged ranges.
For example, a report might have A1:D1 merged for its title and A3:B3 merged for a section label. Selecting A1:D3 and choosing Unmerge Cells restores both ranges. The title remains in A1, and the section label remains in A3; other cells in the former merged ranges are blank. Unmerged cells elsewhere in the selected block remain ordinary cells.
Excel also offers related merge commands in the same dropdown, such as Merge Across and Merge Cells. Merge Across creates separate merged ranges for each row of a selection, while Merge Cells combines the selected area without necessarily centering its contents. If a range was created with one of these options, selecting it and choosing Unmerge Cells still breaks the merged areas back into their component cells.
Common problems and how to fix them
- You cannot find Unmerge Cells: Select a cell that is actually part of a merged range and open the Merge & Center dropdown on the Home tab. If no merged cell is selected, the command may not be available.
- The command is unavailable: The worksheet may be protected, preventing changes to its layout. If you are authorized to edit it, use Review > Unprotect Sheet, supplying a password if required. A workbook owner may need to provide access.
- Text seems missing after unmerging: Check the upper-left cell first. Other values may have been discarded when the merge was created, and unmerge cannot restore them. Try Undo, a backup, or version history if the loss was recent.
- The heading still looks centered across the row: The cells may be unmerged but retain alignment formatting, or the text may visually overflow into blank neighboring cells. Select the anchor cell and check its alignment settings; check borders as well.
- Sorting or filtering still behaves awkwardly: Other merged ranges in the data area may remain. Find and unmerge them, or use a layout without merged cells in the records you need to sort or filter.
There is an important table-related limitation: Excel tables are designed around consistent, individual cells in each row, and merged cells are not permitted inside a table. If a data range will be sorted, filtered, or converted to a table, unmerge its cells first and make sure each row has a clear value in each relevant column.
When to use an alternative to merging
Merging can be convenient for a title above a report, but it often creates friction in data areas. A merged cell can interfere with selecting, filling, sorting, filtering, copying, or applying formulas consistently. It can also make a worksheet harder to navigate with a keyboard or assistive technology because several grid positions appear as one cell.
If your goal is simply to center a heading across several columns without combining the cells, use Center Across Selection instead. Select the cells, open the Format Cells dialog from Home > Alignment using the small dialog launcher, then on the Alignment tab choose Center Across Selection in the Horizontal list. The cells stay separate, so the layout is generally easier to work with than a merged range. This setting centers the text in the leftmost selected cell across the selection; it does not distribute the text among the cells.
For structured data, a stronger alternative is to place the heading in one cell and use formatting, column widths, or a separate title row to make it clear. Keep one value per cell in lists such as dates, names, and sales records. For a heading that needs a visual group, consider applying a fill or border across the range rather than merging it. These approaches reduce problems when you later need to sort, filter, select, or reuse the data.
Excel for Mac and Excel for the web
In Excel for Mac, select the merged cell or range and use the Home tab’s Merge & Center dropdown, then choose Unmerge Cells. The ribbon labels are similar to Windows, although their placement can differ with the window size and Excel version. Mac keyboard shortcuts and ribbon key tips are not the same as the Windows Alt sequence, so use the menu command if you do not see an equivalent shortcut.
In Excel for the web, select the merged area and look for Unmerge Cells in the Merge & Center menu on the Home tab. The browser interface may arrange ribbon controls differently from the desktop app, but the effect is the same: the merged range becomes individual cells and its surviving content stays in the upper-left cell. If the command is unavailable, check whether the sheet is protected or whether you have editing permission.
A safe workflow before unmerging
If the workbook matters, take a moment to protect information before changing its layout. Unmerging itself is straightforward, but it may expose a prior data loss caused by merging, or make a heading look different from the intended design. A quick review helps distinguish those cases.
- Save a copy of the workbook before making broad changes, particularly if you are unmerging many ranges.
- Check whether the merged area contains a formula or value in its upper-left cell that needs to be preserved.
- If you need content from the other cells, first check Undo, an earlier saved version, or another source; unmerge will not recover discarded values.
- After unmerging, inspect the cells, alignment, borders, and any nearby sorting or filtering controls.
For a single heading, there is usually no need for a complicated process. Select the merged cell, choose Unmerge Cells, and then adjust the formatting if necessary. For a large worksheet, identify why the cells were merged before removing the layout; a report title and a row of transaction data have different needs.
Frequently Asked Questions
Can I unmerge cells without losing data?
Unmerging preserves the value or formula in the upper-left cell, but it cannot restore values already removed when the cells were merged. If the merge just happened, use Undo before doing anything else. Otherwise, check a backup or version history for the missing content.
Where does the text go when I unmerge cells?
The full value or formula stays in the upper-left cell of the former merged range. The other cells become separate cells and are usually blank. Excel does not split a sentence across the restored cells.
Can I unmerge multiple cells at once?
Yes. Select a range that includes the merged areas and choose Home > Merge & Center > Unmerge Cells. Review the affected ranges afterward so you can confirm that the retained values and formatting are where you expect.
Why is Unmerge Cells grayed out?
The selected cell may not be merged, or the worksheet may be protected. Select a cell inside the merged area and check the Merge & Center dropdown. If the sheet is protected, ask the owner or unprotect it if you have permission.
Does unmerging restore the original cell contents?
No. It restores the cell layout, not values that were discarded during merging. Only the upper-left cell’s content normally survives the merge, so use Undo or recover an earlier workbook version to retrieve other data.
Related
- Excel Borders Not Showing? Causes, Checks, and Fixes
- Border Lines in Excel: Add, Change, and Remove Them
- Excel Borders: How to Add, Change, and Remove Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Row Limit: How Many Rows Can a Sheet Hold?A worksheet in current Microsoft Excel for Microsoft 365 can hold 1,048,576 rows, numbered 1 through 1,048,576. That…
- Excel Data Entry Form: Add an Image Box Step by StepTo add an image box to an Excel data entry form, place a picture in a worksheet cell…
- Google Sheets FILTER Function: How to Filter ArraysIn Google Sheets, the FILTER function returns only the rows or columns that meet conditions you specify. It…
- How to Accept All Track Changes in WordTo accept every tracked edit in a Word document, open the Review tab, open the Accept menu, and…
- Sort Highest to Lowest in Google Sheets: A Clear GuideTo sort values from highest to lowest in Google Sheets, select the full data range, choose Data >…
- How to Find Archived Emails in OutlookTo get archived emails in Outlook, open the Archive folder in your mailbox or search for a message…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.