How to Merge Cells in Google Spreadsheet – 2019

The blog post will teach you quick and easy steps on how to merge cells in Google Sheets.

How to Merge Cells in Google Doc - 2018
Image: geekermag.com/vineydhiman

Google Doc, the popular office suite from Google. The services offer various applications that let the user create and edit documents. Apart of them, it provides users spreadsheet app using which users can create, organize and present the tabular data.

While creating a document sometimes users get them into the situation when they want to merge cells, but unable to do it because they don’t know the exact steps. Even lots of the users are confused about the availability of functionality?

Fortunately, the Spreadsheet app in Google Docs offer a feature using which users can merge cells, the single boxes available on the page. With the help of this function, the users can combine multiple nearby cells which in result create a single larger cell.

Usually, the users would like to merge cells when they need a big cell in a spreadsheet. The users can do that by selecting all the cells that they want to combine by executing the Merge cells command.

In case, you don’t know how to do that, then follow the steps discussed in upcoming lines.

How to Merge Cells in Google Sheets

1. Head over to the spreadsheet in which you want to merge cells. You can visit here (https://docs.google.com/spreadsheets/u/0/) if you’re going to learn how to use the function.

2. Next, you need to Select the cells which you want to merge. It usually can be done by dragging the mouse over the cells.

select cells in google docs

3. To merge cells, you need to take help of Merge cell function. It is available on the Google Docs toolbar. Here’s how it looks like “Merge cells Merge cells.”

merge cell icon in google docs

You need to click on the down arrow next to it. The Merge cell function will show you additional options to merge cells which includes:

  • Merge All
  • Merge Horizontally
  • Merge Vertically
  • Unmerge

Here’s how following functions merge the cells:

Merge All

merge cells in google docs

It will merge selected cells horizontally and vertically and turn them into a big box.

Merge Horizontally

merge cell horizontally in google docs

It going to merge selected cell horizontally

Merge Vertically

merge cell vertically in google docs

It will merge selected cell vertically

In case, you have mistakenly join unwanted cells; then you can choose the Unmerge option. It works like Undo feature.

You can experiment with these options to get more out Merge cell feature.

I hope you find this blog post on how to merge cells in Google Sheets helpful. Feel free to share your thoughts in the comments.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.