How to merge multiple cells on Google Sheets exactly the way you want

The process of merging multiple cells on Google sheets is not complicated, but you should know the exact way of doing it. 

- Advertisment -

Among the cool formatting options available on spreadsheet programs, one of them is the ability to merge multiple cells, so that you can use the complete space of all the merged cells to enter some information without affecting the alignment of the corresponding cells in the same horizontal or vertical line. Apart from the horizontal and vertical merging of cells, you can even merge all the cells completely for your specific requirements, especially for writing or entering long information within the cell. When it comes to Microsoft Excel, you can easily merge multiple cells by going to the ‘Format Cells…’ option, however, it is slightly different on Google Sheets.

It is almost a year now that I am using Google Sheets for all my requirements associated with spreadsheets, and sometimes I also need to merge multiple cells for different requirements. The ability to merge cells vertically and horizontally is available on Google Sheets,  however, you can even do it manually on Microsoft Excel by selecting the cells that you want to merge, individually. The process of merging multiple cells on Google sheets is not complicated, but you should know the exact way of doing it. 

So,  show without any further delay, let’s get started with how you can merge multiple cells on Google sheets.

Merging cells in Google Sheets

Step 1: Open Google Sheets, create a new sheet in the usual way and select the cells that you want to merge.

Merging cells on Google Sheets 10

Step 2: Now, click on ‘Format’, and choose the type of merging that you want to do, under the ‘Merge Cells’ menu.

Merge cells horizontally or vertically Google excel

If you choose ‘Merge horizontally’, all the cells that belong to the same row, within the selection, will be merged. With ‘Merge vertically’, all the cells that belong to the same column within the selected range of cells will be merged. The last option, which should, however, be on the top, will merge all the selected cells, and it is self-explanatory.

Merging cells

Just select ‘Unmerge’ by selecting all the cells, and they will be immediately unmerged, no matter, which way you merged them together. 

After you unmerge the cells, the information within the cell, if any, will move to the top-most, left-most, or top left-most cells within the selection for horizontal, vertical, and merging all cells respectively.

However, if you merge the cells, and you merge all the cells together, the information within the top left-most cell will retain, and in case of horizontal and vertical merging, only the information on the left-most and top-most cell will remain. The other will be deleted, and this is something you should remember.

So, that was all about, how you can merge multiple cells on Google Sheets. Do you have any questions? Feel free to comment on the same below.

Sarbasish Basu
From B.Tech (Hons.) Electronics & Instrumentation Engineer to Photography and Writing blogs; he ultimately has answers to everything. Oh, and he's also quite good in rapidly building a relationship and set up the trust; his articles are proof of that...


Please enter your comment!
Please enter your name here

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

Latest Posts

Best 5 Free Apps to Create Bootable USB drives in 2020

Do you need to install an operating system in your Computer? Then quickly grab a CD or DVD and...

Top 5 URL Shortener / Short Links / Link Shortener services for Beginners

More or less most of us have heard about short links, which can be used to put off long,...

Top 8 apps that you should download on Amazon Fire TV Stick (India)

The Amazon Fire TV Stick is one of the finest streaming devices available in the market and is also...

Corsair iCUE 220T RGB Airflow Mid Tower Smart Case Review

Corsair is one of the prominent name in the computer peripheral industry and especially for RGB...
- Advertisement -


In Taipei, a gaming brand TEAMGROUP has announced its mirror design T-FORCE XTREEM ARGB Gaming Memory modules to add...

₹ 1.9 lac premium Devialet Phantom Reactor 600/900 now in India to rock

Recently, Devialet hosted an event in India (Delhi) to introduce Phantom Reactor, a premium speaker that looks like some...
- Advertisement -

You might also likeRELATED
Recommended to you