Unmerging all merged cells

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 2016

    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:
Alignment group in Excel 2016

    3.    In the Merge & Center list, select Unmerge Cells to unmerge all cells in the selected area:

Unmerge cells in Excel 2016

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.