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.
Step 2: Click Format > Merge > Unmerge Cells
From the Format menu in the top tool-bar select Merge cells followed by Unmerge.
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.
How to Unmerge All Cells in Google Sheets
Step 1: Select a Merged Cell
We must first select any merged cell in the dataset.
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.
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.
By selecting the drop down arrow next to the merge button, a shortcut menu will be displayed containing several options.
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.
Related Articles
-Merge Cells Shortcut in Google Sheets
-Merge Cells and Keep Data in Google Sheets
