How to Unmerge Cells in Google Sheets

Merging cells in a spreadsheet is useful when you are formatting data and have a section where you need to display information across many cells. But it can also cause a bit of a headache when you are sorting and moving data, and you may find yourself with some merged cells that no longer need to be merged.

Luckily you can unmerge cells in Google Sheets in a manner similar to how those cells were merged in the first place. Our guide below will show you how to select a group of cells in your spreadsheet that have been merged, then perform an action on those cells to unmerge them.

Can I Unmerge Cells in Google Sheets?

The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop browsers like Edge or Firefox.

Step 1: Sign into your Google Drive at https://drive.google.com and open the Sheets file containing the cells to unmerge.

Step 2: Select the cells that you wish to unmerge. Note that you can select multiple cells, but they must be adjacent. You can even select unmerged cells and unmerge them, it just won’t change anything.

select the cells to unmerge

Step 3: Click the Select merge type button, then choose the Unmerge option.

how to unmerge cells in google sheets

Curious about the options that you have for merging cells in Google Apps, including Google Docs? Find out more about merging cells in Google Sheets and Google Docs.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.