Home How to How to Merge Cells in Google Spreadsheet - 2020

How to Merge Cells in Google Spreadsheet – 2020


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, a popular office suite from Google. The services offer various applications that let the user create and edit documents. Apart from 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 users are confused about the availability of functionality?

Fortunately, the Spreadsheet app in Google Docs offers 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
Merge cells

3. To merge cells, you need to take the help of Merge cell function. It is available on the Google Docs toolbar. Here’s how it looks like ” 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 the 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 an Undo feature.

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

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.

If you find this blog post useful, please share it on Social Media. A quick share will help in growth of this blog. It hardly takes 10 seconds, isn't it?
Viney Dhimanhttps://geekermag.com/
Himachali, Mechanical Engineer, Webmaster at Geeker Mag, Follow it on Telegram https://t.me/geekermag | https://about.me/deadbycrushing


Please enter your comment!
Please enter your name here

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

Related to Tags

(Fix) Google Sheets – A loading error occurred. Please press ‘Reload’...

The following blog post has a quick workaround on how to fix Google Sheets document "A loading error occurred. Please press 'Reload'...

Related to Category

How to Enable and Use Tab Search Feature in Google Chrome

Chrome Devs are frequently working on improving user's experience in the browser with multiple open tabs. To achieve this thing, they have...