How to Merge cells in Google Sheets on Desktop or doc or Mobile to combine multiple cells into one single cell

by

This article is giving brief of “How to Merge cells in Google Sheets on Desktop or doc or Mobile to combine multiple cells into one single cell” – Introduction, Merging cells has some simple steps like, Merge cells in google sheets options / shortcut / quick keys, How do I merge cells in google sheets?, How to merge cells in a google doc?, How to merge cells in google sheets on mobile?

Types of mergeHorizontal | Vertical | Merge all
BenefitsBetter presentation of data

Introduction

You can merge two or more cells into one large single cell using this merging feature on Google Sheets.

For e.g. suppose there is any category with several sub-categories inside it like Region with several regions name inside it i.e

  • Main category: Region
    • Sub-categories:
      • North America
      • South America
      • Europe
      • Asia
      • Middle East etc.

So, to represent the above case visually there can be one merged cell with text ‘Region’ in it and several cells below it with actual regions texts in it.

The above discussed example is shown in this article later.

There are various kinds of merge possible in Google Sheet like:

  • Horizontal merge
Merge cells horizontally in Google Sheet.
  • Vertical merge
Merge cells vertically in Google Sheet.
  • Merge all cells
Merge multiple rows and columns cells into one in Google Sheets.

Merging cells has some simple steps like:

  1. Open spreadsheet on your computer or mobile.
  2. Select the cells you want to merge.
  3. Click on merge icon from format bar in case of desktop or from CTA present at the bottom in case of mobile.

And this merging option is available on web, mobile as well as tablet version of Google Sheet. Just the placement of this feature on web and mobile version is different.

On desktop version this feature is available inside format option on top and on mobile app it is available at the bottom.

This merge option is available in almost all applications and similarly you can find it on Google Sheets as well.

Reason why this is used is to create a common title for multiple columns or rows.

Merge cells in google sheets options / shortcut / quick keys

In Google Sheet web version when you will click on merge icon the below window opens which has options to:

  • Merge vertically
  • Merge horizontally
  • Unmerge etc.

as shown below in image. So, the options are pretty clear i.e. what they do or what will happen when we will click on it.

Different options available under merge icon.

The below table shows how to apply merge cells using keyboard or shortcut to merge cells on google sheets. But, please note that cells need to be selected before using any shortcut.

MacCtrl + Option + O, M , EnterOn clicking ‘Ctrl + Option + O, M’ merge menu as shown in above image opens and on pushing enter final merging happens.
WindowsAlt + O, M , EnterSame as explained above.
Google Sheets merge cells shortcut.

How do I merge cells in google sheets?

Merge cells helps in better visualisation otherwise continuous repetitive words in a column does not looks good.

Step 1:

  • Select the cells you want to merge on x-axis or y-axis.

Step 2:

  • Go on top bar and click on merge icon. Refer the image below to see where the merge icon is present.
Merge cells vertically in google sheets.

So, we can how applying the merge cells in above case converted “Dairy product” being written in three cells into one and hence improved the overall visualisation.

So, this merge cells in google sheets can be used to merge cells of any grid that is of dimension 4×6, 5×5, 7×7, 8×8, 8×10 etc.

There is not as such any limitation on number of cells you can merge on google sheeets.

How to merge cells in a google doc?

Merge cell option is also available on google doc but first you need to create some table.

Once you create the table then follow the below 2 steps to merge cells in it.

Step 1:

  • Select the cells that you want to merge.

Step 2:

  • Right click and select or click on the merge cells options. Refer the image below for seeing how this is done.
Merge cells in google doc.

Following, the steps mentioned above you can see how 4 rows are merged into one. So, visually it is looking much better now.

Merge cells options is looking somewhat small in the above image, but I hope you guys are able to grasp the concept that we are trying to show here i.e. after right click where this merge option will be available.

How to merge cells in google sheets on mobile?

You can use this merge cell option on mobile as well.

Prerequisite is google sheet application should be installed on your mobile, if not you can download it easily from the app store.

Once you download it merging cells on mobile application is even easier than web version, here selecting cell and merging cells are like one tap thing.

Refer the image below for how you can do it.

Step 1:

  • Open a Google Sheet on your mobile and go to the sheet where you want to apply merge cells.

Step 2:

  • Click on merge icon available on at the bottom, refer the image below to see where it is available and how to apply it.

As soon as you will click on merge icon the selected cells will be merged into one.

Google sheet merge cells on mobile.

So, see as mentioned it’w quite quick and easy on mobile than web.

Further Read:

How to merge cells in google sheets on ipad?Merging on ipad will be similar android case only, there might be hardly any difference.
Merge cells in google sheets by dateUnmerge Multiple (or All) Cells in Excel & Google Sheets
Merge cells in google sheets javaMerge cells in google sheets not working
Merge cells in google sheets not workingMerge cells in google sheets pivot table

Other Google Sheet Tutorials:

The below set of tutorials on googlesheet is to grasp more knowledge.

Final Words:

I hope this article “How to Merge cells in Google Sheets on Desktop or doc or Mobile to combine multiple cells into one single cell” has provided you some value, if your answer is no then please let us know what we can do to improve the quality of content we will try our best to get the relevant information for you.