How to Unmerge Cells in Google Sheets (The Easy Way!)

In this article we will show you exactly how to unmerge cells in Google Sheets. We cover how to unmerge a selection of cells or all cells. Just follow the simple steps below:

How to Unmerge Cells in Google Sheets (Highlighted Range)

An example dataset was created for the purpose of demonstration. Click here to access the sample sheet and follow along at home.

‍

Step 1: Select the Cell you Want to Unmerge

Click on the merged cell highlighting it.

*Separate cells in Google Sheets: Select a merged cell*

‍

Step 2: Click Format > Merge > Unmerge Cells

From the Format menu in the top tool-bar select Merge cells followed by Unmerge.

*Separate cells in Google Sheets: Menu method*

‍

Step 3: View the Results

The merged cells are unmerged. We can see in our example that the previously merged cell is separated and the contents appear in the top left-most cell.

*Separate cells in Google Sheets: Results*

How to Unmerge All Cells in Google Sheets

‍

Step 1: Select a Merged Cell

We must first select any merged cell in the dataset.

*Separate cells in Google Sheets: Select a cell*

‍

Step 2: Apply the Selection to all Cells

Press Ctrl + A in Windows (cmd + A in Mac) to expand the selection to the full data set, with the Ctrl (Cmd) key held down - press A again which will select all of the cells in the sheet.

*Separate cells in Google Sheets: Select all*

‍

Step 3: Select Format > Merge > Unmerge Cells

From the top tool-bar click Format followed by select Merge cells and then Unmerge from the side-menu.

‍

Step 4: View the Results

We can now see that all the previously merged cells in the sheet have been separated and now display individually, Any contents appear in the top left-most cell.

‍

Unmerge Google Sheets Shortcut

Step 1: Select a Merged Cell

Select the merged cell you wish to separate in your dataset.

‍

Step 2: Click the Arrow Next to the Merge Button

In the top tool-bar notice the merge button.

*Separate cells in Google Sheets: Merge shortcut*

‍

By selecting the drop down arrow next to the merge button, a shortcut menu will be displayed containing several options.

*Separate cells in Google Sheets: Shortcut menu*

‍

Step 3: Click Unmerge and View the Results

From the merge shortcut menu select Unmerge, the merged cells will become unmerged and you will be able to see each individual cell. Any cell contents appear in the top left-most cell from the selection.