How to Unmerge Cells in Google Sheets (Quick Guide)

Merging cells is quite common when you’re working with data in Google Sheets.

A lot of times, people merge cells while creating headers or labels.

And you can also easily unmerge cells in Google Sheets. The process is quite similar to what you do when you have to merge cells.

How to Unmerge Cells in Google Sheets

Suppose you have the dataset as shown below and you want to unmerge a specific range of cells (B1:D1)

Data set that has merged cells that need to be unmerged

Below are the steps to do this:

  1. Select the range that you want to unmerge
  2. Click the Format option in the menuClick the Format tab
  3. Hover the cursor over the Merge Cells option
  4. Click on UnmergeClick on the Unmerge option

The above steps would instantly unmerge the selected cells.

Note that the unmerge option appears only when you have selected at least one merged range.

There is another (faster) way to unmerge cells in Google Sheets.

There is an option in the toolbar in Google Sheets that also has the option to unmerge.

Below are the steps to unmerge cells using the toolbar in Google Sheets:

  1. Select the range that you want to unmerge
  2. In the toolbar, there is a ‘Merge cells’ icon. Click on the small triangle at the right of itClick on the merge cells icon in the toolbar
  3. In the options that appear, click on the ‘Unmerge’ option.Click on the Unmerge option in the toolbar

So there are two quick ways to unmerge cells in Google Sheets.

In case you have a lot of merged cells in the worksheet and you want to quickly unmerge all the cells at one go, select all the cells in the worksheet and then use any of the methods shown above. To select all the cells at one go, use the keyboard shortcut Control + A + A

The Problem with Merged Cells (And Why you may need to Unmerge Cells)

If you’re wondering why you may want to unmerge cells, let me give you some reasons.

With merged cells, you will not be able to properly sort or filter the data.

Another huge frustration I have with merged cells is that you try to select cells in a column that has a few merged cells. it automatically expands the selection to include these extra columns that have the merged cells.

When you Unmerge cells in Google Sheets, it gets rid of these problems.

You may also like the following tutorials about Google Sheets:

Leave a Comment