NorthStar Analytics

HiDocs High-Quality Ghost Documentation Theme

How to merge cells in Google Sheets?

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


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!

Make your business data transparent!
  • Subscribe to a package

    Subscribe and explore the limits of your business with data or thinking to expand your agency value proposition with Google Data Studio dashboards?

  • Request unlimited dashboards

    You can request as many dashbaords you might have and as many revisions as you might need. We create a queue of your tasks, the first tasks that come in are the tasks that we’ll deliver first.

  • Your Data Studio Department

    Optimise your business with complete transparency through dashboards or provide value-added Google Data Studio service to your agency clients.

Make your business transparent

The fastest easy-to-use Google Data Studio dashboards without any recurring cost.