Unmerge Multiple (or All) Cells in Excel & Google Sheets

This tutorial demonstrates how to unmerge cells in Excel and Google Sheets.

Unmerge Cells

In the following example, cells B2:C3 are merged into one cell with the text from B2 (“Product name”). If you want to unmerge the cells, follow these steps:

1. To unmerge cells, first select the merged cell (B2).
2. In the Ribbon, go to Home.
3. Click on the arrow next to the Merge & Center icon.
4. Choose Unmerge Cells.
   Tip: When you select a merged cell, you can also click directly on the Merge & Center icon to unmerge it.

As a result, cells are unmerged and back to their initial state: There are four individual cells (B2, B3, C2, and C3), and cell B2 contains the text from the merged cell.

Apart from using the Ribbon options, you can also use a shortcut to unmerge multiple cells.

Unmerge All Merged Cells in a Worksheet

In the previous example, you saw how to unmerge one merged cell, but you could also run into a situation where you need to split all merged cells in a worksheet. You can easily do this in one step. Say you have the following example with four merged cells (B2, B5, B8, and B11).

To unmerge them all at once, first select all cells in the sheet (by clicking the arrow in the upper-left corner of the cells, or using the keyboard shortcut CTRL + A). Then in the Ribbon, go to Home > Merge & Center.

As a result, all merged cells are now split into their original cells.

Unmerge Cells in Google Sheets

You can unmerge cells in Google Sheets similarly.

1. Select the merged cell (B2).
2. In the Toolbar, click on the arrow next to the Merge cells icon.
3. Choose Unmerge. (As in Excel, you can also click Merge cells.)

As a result, all cells are now unmerged.

As shown above for Excel, you can also unmerge all cells in a Google Sheets tab at once by selecting the whole sheet.