Google Sheets are similar to Microsoft Excel sheets but these are cloud-based sheets. Google Sheets provides multiple features to manage and display the information in rows and columns. The formatting of these rows and columns is supported with the help of different tools. One of these tools is “Merging cells”, which is used to merge multiple cells into a single cell.
This blog will help the readers in understanding the method of merging cells in Google Sheets with the help of the example.
Why Do Cells Merged in Google Sheets?
There are three major reasons for merging the cells in Google Sheets which are:
- Formatting: Merging cells creates an organized spreadsheet that is visually appealing.
- Readability: Merging cells make the readers able to understand the long data after reading it easily.
- Printing: Merging cells make the spreadsheet be printed into a single sheet.
How to Merge Cells in Google Sheets?
To merge cells, the below-mentioned steps should be followed:
- Select the cells that are supposed to be merged. This can be done either by dragging the mouse to make the selection or pressing the “Shift” key, then selecting the multiple cells.
- After making the selection of cells, there are two different methods to merge them. Either click on the “merge” icon in the toolbar menu, or click on the “Format” in the menu bar, and then select “Merge cells”.
- Choose the type of merging cells either vertically or horizontally.
- Cells are merged successfully.
Example: Merge Cells in Google Sheets
Consider a Google Sheet to understand the above steps. Let’s explore the method to merge cells by the above-mentioned cells.
Step 1: Select the Cells in Google Sheet
Select the cells in Google Sheets which are supposed to be merged. This can be done either by selecting the cells by dragging the mouse, or by clicking the cells while holding the “SHIFT” key:
Step 2: Merge the Cells in Google Sheets
After making the selection of the cells in Google Sheets, there are two different methods to merge the cells.
Method 1: Merge the Cells by Using the “Merge Icon” on Google Sheet
The first method is to click on the “Merge icon” in the toolbar after making the selection of the cells in Google Sheets:
Method 2: Merge the Cells by Clicking on the “Format” in Google Sheets
Another method to merge the cells is selecting the cells, and then clicking on “Format” in the top menu bar. A drop-down menu will appear, click on the “Merge cells”:
How to Use the Type of the Merge Cells in Google Sheets
There are three different options for merging cells which are “Merge all”, “Merge vertically”, and “Merge horizontally”:
If the “Merge all” option is used, all the selected cells will be merged into a single cell:
If the “Merge vertically” option is used, the selected cells are merged vertically:
If the “Merge horizontally” is selected, then the cells will be merged horizontally:
This is the method by which the cells are merged in Google Sheets to make it visually appealing.
How to Unmerge the Cells in Google Sheets?
To unmerge the cells in Google Sheets, select the merged cells, then click on “Format” in the menu bar, and then “Merge cells” in the drop-down menu. After clicking on the “Merge cells”, click on the “Unmerge”:
The cells are unmerged in Google Sheets successfully:
To merge the cells in Google Sheets, select the cells which are to be merged, and then click on the “Merge icon” in the toolbar. Another method is to click on the “Format” in the menu bar and select “Merge cells”. Both methods are explained with the help of a simple example in this blog to merge cells in all possible ways.