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.
Step 3: Click the Select merge type button, then choose the Unmerge option.
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.
- How to merge cells in Google Sheets
- How to wrap text in Google Sheets
- How to alphabetize in Google Sheets
- How to subtract in Google Sheets
- How to change row height in Google Sheets
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.