To unmerge cells in Microsoft Excel for Microsoft 365 on Windows, select the merged cell or range, then choose Home > Merge & Center ▼ > Unmerge Cells. Excel keeps the value in the merged area’s upper-left cell and leaves the other cells blank; it does not restore values that were discarded when the cells were merged. If you need those original values, use Undo immediately or recover an earlier workbook version before making more changes.
Unmerging restores the individual cell grid, which can make a worksheet easier to edit, sort, filter, or use as a source for formulas. It does not necessarily restore the original layout or formatting, so check the affected range afterward. The instructions below cover the current Microsoft 365 desktop app on Windows, with notes for Excel for Mac and Excel for the web.
What You’ll Need
- An editable Excel workbook. If it is read-only, open an editable copy or ask the file owner for permission.
- The merged cell or range you want to change. You can also unmerge every merged range on a worksheet if that is your goal.
- If the workbook contains important data, save a copy first. Unmerging is reversible with Undo right away, but later edits can make that harder.
Step-by-Step
- Open the worksheet and find the merged area. Click the relevant worksheet tab, then locate the cell that spans multiple rows or columns. A merged area behaves like one large cell: clicking any part of it selects the entire merged area, and the Name Box to the left of the formula bar can show its address. If the merge is hard to spot, click a likely cell and look for the Merge & Center control on the Home tab. The control may appear active when the selection contains a merged cell.
- Select only the cells you intend to unmerge. Click the merged area once. For several merged areas, drag across them or hold Ctrl while selecting non-adjacent areas on Windows. If you select a larger range that includes merged cells, Excel can unmerge the merged areas within that selection; check the selection carefully, especially if it includes headings or layout elements. A selected merged area can extend beyond the visible portion of the sheet, so use the Name Box to confirm its address when needed.
- Open the merge options on the ribbon. Choose the Home tab. In the Alignment group, find Merge & Center. Click its small drop-down arrow rather than the main button. The drop-down contains the available merge actions. If the ribbon is simplified or the window is narrow, the control may be compressed; widen the Excel window or expand the ribbon to reveal the command.
- Choose Unmerge Cells. Click Unmerge Cells in the drop-down. The merged area separates into its original grid of individual cells. On Windows, you can also use the ribbon access-key sequence Alt, H, M, U: press each key in order, then choose Unmerge Cells if the menu presents that option. Keyboard access keys can vary with ribbon layout or localization, so the visible menu command is the reliable option.
- Check what happened to the contents. Excel keeps the value or formula from the upper-left cell of each merged area. The remaining cells become blank. For example, if B2:D2 was merged and contained the heading Revenue, after unmerging B2 contains Revenue while C2 and D2 are empty. If values had been entered in other cells before the merge, merging would have retained only the upper-left content; unmerging cannot bring the discarded contents back.
- Review formatting and alignment. Look at borders, fills, text alignment, row heights, and column widths around the newly separated cells. Unmerging restores cell boundaries, but it does not recreate a prior design automatically. You may need to adjust alignment or apply borders and fills to match neighboring rows. If the cell had been merged across columns, the individual column widths stay as they were; unmerging does not resize columns to fit the former merged text.
- Save the workbook after checking the result. If the sheet looks right, press Ctrl+S on Windows. Keep the backup if the change affects a template or shared workbook. If the result is not what you expected and the change was just made, press Ctrl+Z before doing anything else. On Mac, use Command+Z to undo.
To unmerge every merged cell on a worksheet: click the Select All button at the top-left intersection of the row numbers and column letters, then choose Home > Merge & Center ▼ > Unmerge Cells. This affects all merged areas on the active worksheet, not every sheet in the workbook. Repeat on other sheets only if you mean to change them too. Consider saving a copy first because a sheet may use merged cells as part of its layout.
On Mac or Excel for the web: select the merged area and use the Home tab’s Merge & Center drop-down, then choose Unmerge Cells. Ribbon spacing and labels can vary slightly by release. On Mac, use Command+Z to undo; the Windows Ctrl+Z shortcut does not apply. Excel for the web uses the browser-based ribbon, but the same select-and-unmerge approach is available when you have edit permission.
Common Mistakes
- Expecting all the old contents to return. Unmerge only separates the cells. It does not recover text or numbers removed when the cells were first merged. If you need those contents, try Undo immediately if the merge was recent, or restore an earlier version of the workbook.
- Unmerging the whole sheet by accident. Selecting all cells and choosing Unmerge Cells removes every merge on the active worksheet. That may disrupt title rows, section headings, or print layouts. Select a specific range unless you intend to clear all merges.
- Clicking Merge & Center instead of its arrow. The main button applies a merge action; depending on the current selection, it can merge cells rather than show the list. Use the small drop-down arrow and choose the clearly named Unmerge Cells command.
- Assuming a large selection contains only one merge. A selection can include several merged areas, including ones that are partly off-screen. Check the highlighted range and inspect the sheet before applying the command, particularly in a formatted report.
- Confusing unmerging with splitting a cell. Excel cells cannot be split into smaller cells in the way a word-processing table cell can. Unmerge reverses a prior merge and reveals the original grid; to create a different layout, adjust row or column structure separately.
Tips
- Use Center Across Selection for headings that should look centered without merging. Select the cells across which the heading should appear, open the Format Cells dialog with Ctrl+1, choose the Alignment tab, set Horizontal to Center Across Selection, and click OK. This keeps cells separate, which is generally more convenient for sorting and selecting data. On Mac, use Command+1 to open Format Cells.
- Keep labels in one cell per record. Merged cells inside a list or table can interfere with sorting, filtering, copying, and some data-analysis operations. For a dataset, place a heading in one cell and use formatting or Center Across Selection for appearance instead of merging across data rows.
- Use Find to locate merges when the sheet is large. Press Ctrl+F on Windows, select Options if necessary, then use Format to search for cells with a particular format. In Find Format, use the Alignment tab and look for the Merge cells setting. Search settings can be easy to overlook, so clear the format criteria after the search if you want ordinary text searches again. Mac shortcuts differ: use Command+F to open Find.
- Consider accessibility and screen readers. Merged cells can make it harder to navigate tables consistently. For worksheets shared with others, a simple unmerged grid with clear headings is usually easier to read and work with.
- Use Undo before trying several fixes. If an unmerge changes the layout in an unexpected way, undo once, check which cells are selected, and repeat with a narrower selection. Avoid continuing to edit before deciding whether to keep the change, because Undo also reverses later actions in sequence.
Troubleshooting
Unmerge Cells is unavailable or the command appears disabled. Check that the selection actually contains a merged cell. If you clicked elsewhere, the command may be inactive. If the workbook or worksheet is protected, go to Review and check whether Unprotect Sheet is available; you may need the password or help from the workbook owner. Also check whether the file is opened read-only or in a view that prevents editing. In Excel for the web, confirm that you have edit access rather than view-only access.
The command changes more cells than expected. Press Ctrl+Z on Windows or Command+Z on Mac immediately. Then click a single merged area instead of selecting a full row, column, or sheet. If you want to clear merges everywhere, use Select All deliberately and verify that the active worksheet is the correct one before choosing Unmerge Cells.
The text appears only in the first cell after unmerging. This is normal. Excel retains the upper-left cell’s content and leaves the other cells blank. If you need missing content, check Undo history if the merge was just made. Otherwise, look for an earlier saved copy, a version in OneDrive or SharePoint version history, or another source file. Do not type replacement values into the blank cells until you have checked whether you can restore the earlier version.
The result still looks like one wide cell. The cells may be unmerged but formatted with matching fills or borders, or the text may visually overflow into empty neighboring cells. Click the cells individually and check the formula bar or Name Box to confirm they are separate. You can apply borders to show the grid, or adjust alignment and column widths. If the selection still behaves as one cell, repeat the command and verify that the merge was actually removed.
Sorting or filtering still does not work properly. Check the entire data range for other merged cells, not only the one you first found. Also make sure each data column has a single heading row and that there are no blank rows or columns interrupting the list. Unmerging fixes merged-cell obstacles, but it does not automatically turn a formatted range into a clean data table.
Frequently Asked Questions
Does unmerging delete the text in a merged cell?
It keeps the value or formula from the upper-left cell of the merged area and leaves the other cells blank. The retained text is not deleted, although its appearance may change once the cells are separate.
Can I unmerge cells without losing data?
You can unmerge without losing the value stored in the upper-left cell. Other values cannot be restored by unmerging because a merge keeps only that upper-left content. Use Undo or recover an earlier workbook version if you need data that was removed during the merge.
How do I unmerge all cells in Excel?
On the worksheet you want to change, click Select All at the top-left corner of the row and column headings, then choose Home > Merge & Center ▼ > Unmerge Cells. This affects the active sheet only, so check the sheet name and save a backup if its layout matters.
Can I unmerge cells in Excel for the web?
Yes. Select the merged area, open the Merge & Center drop-down on the Home tab, and choose Unmerge Cells. You need permission to edit the workbook, and the exact ribbon spacing may differ from desktop Excel.
Will unmerging restore the cells’ previous formatting?
Not necessarily. The cells become separate, but the prior formatting and layout may not be reconstructed exactly. Review borders, fills, alignment, and column widths, then adjust them as needed.
What if I cannot find the Unmerge Cells option?
Make sure the selected range includes a merged cell, the worksheet is not protected, and you have edit permission. Open the arrow next to Merge & Center rather than clicking only the main button.
Related
- How to Split an Excel Page into Separate Panes
- How to Split an Excel Row in Half
- How to Split an Excel Sheet in Half Without Losing Data
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 Archive Emails in Outlook on Windows 11To archive an email in Outlook on Windows 11, select the message and choose Archive on the toolbar.…
- Removing Formatting in Word: Clear Text and StylesTo remove formatting in Microsoft Word for Microsoft 365 on Windows, select the text and choose Home >…
- Excel Data Validation From a Table Column: How to Set It UpTo make an Excel drop-down list from a table column, create a workbook-level name that refers to the…
- Insert Image in Excel: Steps, Cell Options, and TipsTo insert an image in Excel for Microsoft 365 on Windows, select a cell near where you want…
- Dropdown List in PowerPoint: Options and Setup GuidePowerPoint does not offer a built-in dropdown list like Excel’s data-validation menu. In PowerPoint for Microsoft 365 on…
- Split Cell in Google Sheets: Separate Text Into ColumnsTo split text in a Google Sheets cell, select the cell or range, choose Data > Split text…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.