Merged cells can make headers look neat, but they often interfere with sorting, filtering, formulas, and imported data cleanup. Unmerging restores the original grid so each row and column behaves normally again.
Does this affect you?
Use this for Excel for Microsoft 365, Excel 2021, and Excel 2019 on Windows or Mac when merged cells are blocking normal worksheet work or need to be split back into standard cells.
Unmerge one cell or a small range
Use this when you know where the merged cells are.
- Click the merged cell, or select a range containing several merged cells.
- Open the Home tab.
- Click the dropdown arrow beside Merge & Center.
- Choose Unmerge Cells.
The range becomes separate cells again. The old merged-cell value stays in the top-left cell, and the other cells in that former merged range are left blank.
Unmerge every merged cell on a sheet
Use this for imported sheets or heavily formatted workbooks.
- Click the Select All triangle at the top-left of the sheet, or press Ctrl+A.
- Open Home > Merge & Center dropdown.
- Choose Unmerge Cells.
Every merged cell on that sheet is split in one pass. This is often a good first cleanup step before sorting or building formulas.
More control
Fill blanks after unmerging
After unmerging, select the range, use Go To Special > Blanks, type =, press the Up arrow, then press Ctrl+Enter or Cmd+Return. This fills blanks with formulas pointing to the value above. Copy and Paste Special > Values if you need static text.
Find merged cells
Use Find, open Options, choose Format, go to Alignment, check Merge cells, and click Find All to list merged-cell locations.
Why sorting breaks
Excel needs consistent cell sizes inside the sort range. Merged cells make row boundaries ambiguous, which is why sort errors often mention merged cells needing to be identically sized.
Use Center Across Selection
For titles, Format Cells > Alignment > Horizontal > Center Across Selection gives the same visual effect without merging cells underneath.
Sources
- Microsoft Support – Merge and unmerge cells (2025)
- Microsoft Support – Sort data in a range or table (2025)
- Microsoft Support – Find and Replace in Excel (2025)