How To Unmerge Cells In Google Sheets

In this tutorial, you will learn how to unmerge cells in Google Sheets.

How To Unmerge Cells In Google Sheets

Sometimes when you’re working in Google Sheets you’ll come across cells that have been merged that you need to unmerge.

It will look something like this:

Fortunately, unmerging cells in Google Sheets is simple. Just follow these steps:

Step 1

Select the merged cell or cells you want to unmerge. You can select an entire range that includes all the merged cells you want to unmerge

Step 2

In the toolbar, click on the small down arrow beside the Merge Cells icon to open the merge cells menu

Step 3

In the merge cells menu, click on the last option: Unmerge

Step 4

All merged cells in the selected range will be unmerged.

Note that any formatting that was applied to the merged cells will be applied to all the cells that were merged together even after they are split


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to unmerge cells in Google Sheets. Want more? Check out all the Google Sheets Tutorials.

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.