How to merge cells in Google Sheets?

Combining and categorizing cells makes it easier to work with tables in Google Sheets. Let's see how it helps us.

How to merge all cells?

Cells can be merged in two ways:

1. From Menu
2. From The Toolbar

I will do it from the menu only under this title. I will show how to do it from the toolbar in the following titles. Let's take a look at the menu first.

1. Select the cells you want to merge
2. Menu –>Format
3. Merge Cells –>Merge all

Now let's see how the cells are merged with the icon on the toolbar:

1. Select the cells you want to merge
2. Click the “merge icon” in the toolbar
3. Merge all

It's done!

How to merge cells vertically?

There are two ways (from the menu and from the toolbar). As I mentioned above, I will only show how it is done with the icon on the toolbar:

1. Select the cells you want to merge
2. Click the “merge icon“ in the toolbar
3. Merge vertically

How to merge cells horizontally?

1. Select the cells you want to merge
2. Click the “merge icon” in the toolbar
3. Merge horizontally

How to merge cells in Google Sheets mobile?

Merge operations can be done the same way on mobile devices just as on desktops. It is enough to select the cells you want to merge and click on the “merge” icon.

How to unmerge cells?

If you want to unmerge the cells that are combined;

1. Select the cells you want to unmerge
2. Click the merge icon in the toolbar
3. Unmerge

Conclusion

As cells are merged we have a more decent look. There is a point worth noting here. The cells I showed in the examples were empty. No error occurred while merging blank cells. But if we want to merge the filled cells, we will encounter a warning.

Let's see what happens if there is data in the cell.

In this sample table, the following warning appears when I try to combine the year column:

If we approve this warning, the year column will become like this:

As you can see, the data is gone. Only the top cell remains. When it is done by selecting two rows at once, a warning will re-appear. If you confirm the warning, the table will become as follows.

As you can see, only the top-right cell remains. Other data is gone.

Another point to note is that it does not allow merging cells. If our cells are protected, we must first change the protection settings to take action.

Here we can change the protection and continue the merging.

You can find more information about cell protection here->"How to lock cells in Google Sheets?"

That's it! We discussed the cell merging process and the points to be considered. I hope you found this tutorial useful!