Unmerging all merged cells
Excel
365
Here's a quick way to unmerge all merged cells in a worksheet:
1. Select all cells in the worksheet.
A quick way to do so is to click the triangle at the intersection of the row headers and column headers:
![Select all cells in Excel for Microsoft 365 Select all cells in Excel 365](/images/tips/329_365/1.png)
2. On the Home tab, in the Alignment group:
- If Merge & Center isn't highlighted, there are no merged cells in the selected area.
- If the Merge & Center button is highlighted, click it:
![Merge and Center in Excel for Microsoft 365 Merge and Center in Excel 365](/images/tips/excel_button365/unmerge.png)
3. In the Merge & Center list, select Unmerge Cells to unmerge all cells in the selected area:
![Unmerge cells in Excel for Microsoft 365 Unmerge cells in Excel 365](/images/tips/330_365/1.png)
See also how to put the data from merged cells to all of the unmerged cells.
See also this tip in French: Annuler la fusion de toutes les cellules fusionnées.