In Excel for Microsoft 365 on Windows, select a merged cell, then choose Home > Merge & Center ▼ > Unmerge Cells in the Alignment group. The command is inside the dropdown beside Merge & Center; it is not a separate button on the ribbon.
Where to find Unmerge Cells on the ribbon
Start on the Home tab and look in the Alignment group, usually near the middle of the ribbon. Find the button labeled Merge & Center, then click its small dropdown arrow. Choose Unmerge Cells from the menu. If the ribbon is narrow or the Excel window is small, the group may be compressed, so maximize the window or expand the group to reveal the full command.
You can also use the ribbon key sequence in Windows: press Alt, then H, M, and U, one after another. This opens the Home tab’s merge menu and selects Unmerge Cells. If the displayed Key Tips differ in your Excel build, follow the letters shown on screen. On a Mac, use Home > Merge & Center dropdown > Unmerge Cells; the Windows Alt-key sequence does not apply. In Excel for the web, look for the same command on the Home tab in the Merge & Center dropdown; the ribbon may arrange or collapse controls differently depending on the browser window width.
How to unmerge a cell step by step
- Click the merged cell. If you are not sure which cells are merged, click the suspected area and inspect the formula bar and the selected range on the worksheet.
- Open Home > Merge & Center using the dropdown arrow in the Alignment group.
- Choose Unmerge Cells.
- Check the cells that were part of the merged range, especially if the merged cell contained a heading or other important text.
You do not have to select every cell in a merged range first. Clicking the merged cell is generally enough for Excel to identify and unmerge that range. You can also select a larger range or the whole worksheet and run Unmerge Cells to separate merged cells within the selection. Before doing that on a populated sheet, consider the effect on its layout and content; a broad selection can undo merges used across many sections.
What happens to the contents when cells are unmerged?
Unmerging restores the individual cells in the former merged range, but it does not put old contents back into them. The value or text currently stored in the merged cell remains in the range’s upper-left cell. The other cells in the range become separate, blank cells. For example, if B2:D2 is merged and contains “Quarterly Sales,” unmerging leaves that text in B2; C2 and D2 are blank.
This is an important distinction: unmerging is not an undo history or a recovery feature. If Excel discarded values from other cells when the range was originally merged, Unmerge Cells cannot retrieve them. If the merge was just made, use Ctrl+Z on Windows (or Command+Z on Mac) to undo that action, if it is still available. Otherwise, recover missing material from a backup, version history, or another copy of the workbook where appropriate.
After unmerging, the cells may still show formatting such as borders, fill colors, or alignment, depending on how the range was formatted. Review the result rather than assuming every cell will look exactly as it did before the merge. Unmerge Cells changes the merged-cell structure; it does not automatically redistribute the value or rebuild a previous layout.
Unmerge one range or many ranges
For one merged range, select any part of that merged area and use the command. To unmerge several areas at once, select a range that contains them and choose Unmerge Cells. Excel separates merged cells covered by the selection, while leaving unrelated areas outside it alone. If the worksheet has many merges, you can select the entire sheet by clicking the Select All square at the intersection of the row numbers and column letters, then choose Unmerge Cells.
Whole-sheet unmerging can be useful when preparing a workbook for data cleanup, but it can substantially change the appearance of reports, forms, and title rows. It also will not restore content that was discarded by earlier merges. A safer approach is to save a copy first, or try the command on a representative section and inspect the outcome before applying it broadly.
Why Unmerge Cells may be unavailable
If the command is dimmed or does not appear to do anything, check the current selection and the worksheet’s state. Common causes include:
- The active cell is not merged. Select the cell that visibly spans multiple rows or columns. A large-looking label may simply overflow into empty neighboring cells rather than be merged.
- The worksheet is protected. Protection can prevent formatting changes, including changes to merged cells. If you are authorized to edit the sheet, use Review > Unprotect Sheet; a password may be required.
- You are editing cell contents. If the insertion point is visible in the formula bar or inside the cell, press Esc or Enter to leave edit mode, then select the cell again.
- The cells are inside an Excel table. Merging cells is not supported in a table’s data area. Convert the table to a range if that is appropriate for the workbook, or work with cells outside the table.
- The ribbon is collapsed or compressed. Expand the ribbon or open the dropdown arrow next to Merge & Center; the command may be hidden from the compact layout.
Unmerging versus turning off Merge & Center
Clicking the main Merge & Center button is not the clearest way to find the command you need. That button applies the merge-and-center action to the current selection when the cells are not already merged. To deliberately separate a merged range, use its dropdown and select Unmerge Cells. If the main button behaves differently based on the selected cells, the dropdown makes your intent explicit.
Also, unmerging does not necessarily reverse every part of the original formatting. It separates cells, but you may need to adjust alignment, borders, or column widths afterward. If the goal is simply to center a heading over several columns without combining the cells, consider Center Across Selection instead: open the Format Cells dialog, choose the Alignment tab, and select it from the Horizontal list. This keeps the cells separate, which is often more convenient for sorting, selecting, and working with structured data.
Why merged cells can cause worksheet problems
Merging can make a report heading look tidy, but it can complicate everyday spreadsheet operations. A range with merged cells may not behave as expected when you sort rows, filter a list, paste a block of data, or select cells using keyboard navigation. Merged cells can also make it harder to use a consistent rectangular layout in which each column has one type of field and each row represents one record.
For instance, if a column heading is merged across columns A through C, it is not a substitute for three independent column labels. If the worksheet is intended to hold a sortable list, use a separate heading in each column and keep the data cells unmerged. Reserve merging for presentation areas where the visual grouping matters more than table-like operations. If you inherit a workbook that uses merges throughout, unmerge carefully and then decide whether blank cells need labels, formatting, or other values entered manually.
Frequently Asked Questions
What is the shortcut to unmerge cells in Excel?
In Excel for Microsoft 365 on Windows, press Alt, then H, M, and U in sequence. You can also use the ribbon: Home > Merge & Center dropdown > Unmerge Cells. The Windows key sequence is not the Mac equivalent.
Does unmerging restore the data that was in every cell?
No. The current content stays in the upper-left cell of the former merged range, and the other cells are blank. Unmerging does not recover values that were removed when the cells were merged.
Can I unmerge every merged cell in a worksheet?
Yes. Select the whole sheet using the Select All square above row 1 and left of column A, then choose Home > Merge & Center dropdown > Unmerge Cells. This can alter the worksheet’s layout, so make a copy first if you may need the original arrangement.
Why can’t I click Unmerge Cells?
The selected cell may not actually be merged, the worksheet may be protected, or you may still be editing a cell. A merged cell inside an Excel table is another possibility, because tables do not support merged cells in their data area.
Where is Unmerge Cells in Excel for Mac or the web?
In both, look on the Home tab for the Merge & Center dropdown and choose Unmerge Cells. The control’s placement can vary with the available ribbon width, and the Windows Alt-key sequence is not used on Mac.
Can I center a heading without merging cells?
Yes. In the Format Cells dialog, open Alignment and set Horizontal alignment to Center Across Selection. The cells remain separate, which can be a better choice when the worksheet will be sorted or used as a data table.
Related
- Task List Template Excel Spreadsheet: Set Up and Use
- Tax Audit Form 3CD in Excel: Format and Filing Guide
- Supplier Contact List Template in Excel: Fields and Setup
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Validation List: Allow Multiple Values?Excel’s standard data validation list lets a cell accept one item from a dropdown; it does not let…
- Copy the Same Date Down an Excel Column Without Auto-FillTo copy the same date down an Excel column without Excel increasing it, enter the date in the…
- How to Add Reference Footnotes in Word, Step by StepTo add a reference footnote in Word, place the cursor after the passage you are citing, choose References…
- How to Make Columns the Same Width in Microsoft WordTo make columns the same width in Microsoft Word, open Layout > Columns > More Columns, choose the…
- Lock Cells in Excel for the Web: A Step-by-Step GuideTo lock cells in Excel for the web, leave the cells you want protected marked as locked, unlock…
- Switch Excel Sheet View: Normal, Page Layout, and MoreTo switch an Excel worksheet’s display mode in Microsoft 365 for Windows, select View, then choose Normal, Page…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.