To well organize your spreadsheet, merging cells is a great tool to keep your spreadsheet easy to understand The Google spreadsheet is most commonly used for headers so anyone can identify the content across multiple columns. In this article, you will get to know how to merge cells in Google Sheets.
When you prepare data in the spreadsheet; most often you need to merge the cells to provide specific information about the figures or data you entered in a spreadsheet.
The below example will help you to understand a merging cell, you can notice that the spreadsheet contains five items (A, B, C, D & E) with the sales figures for the last four years. We have merged the cells horizontally (Column B to E) and mention a header “Combined Revenue (in millions)”.
This example will make you understand about the figures of sold five items in the last four years. Also, the amounts that are mentioned year-wise are in millions.
You can merge the above example vertically as well, to do that you need to mention that how many items had been sold during the last four years.
Table of Contents
Types of merge cell option in Google Sheets
Merge All
You can perform this option by selecting the cells and make them one. This would merge all the selected cells (vertically or horizontally). Please make a note that you can merge cells that have adjoining combined. The non-adjoining cells will not be merged.
Merge Horizontally
You can horizontally merge cells through this option and make them one. Even when you select more than one row of cells, it will only merge the cells horizontally.
Merge Vertically
This option will merge all the vertical cells and make them into one. Even when you select more than one column of cells, it will only merge the cell vertically.
Merge cells in Google Sheets using desktop
To merge cells in Google Sheets using the desktop, you need to follow the below steps:
Step 1: Launch a web browser and open a spreadsheet in Google Sheets.
Step 2: Select two or more cells (horizontally or vertically) that you want to merge, and click the “Format” option in the menu bar.
Step 3: From the drop-down menu, click on “Merge cells,” you will notice that some options are not available to perform, depend upon your selection of cells that you want to merge – Merge Horizontally, Merge Vertically, or Merge All.
Note: If you select cells horizontally (i.e. Column wise), then “Merge all” and “Merge horizontally” cells are available to perform. On the other hand, if you select cells vertically (i.e. Row wise), then “Merge all” and “Merge vertically” cells are available to perform.
There is another option available as well; as you will find a “Merge” button in the toolbar between the Borders and Alignment buttons. You can merge the cells accordingly just by click on the “Merge” button, it may be faster than using the “Format” menu option.
Merge cells in Google Sheets using a mobile device
To merge cells in Google Sheets using a mobile device, you need to follow the below steps:
Step 1: Open the Google Sheets app and tap on plus sign “+” on the bottom right of the screen.
Step 2: Select the “New Spreadsheet” option to create a new spreadsheet.
Step 3: Now, select two or more cells that you want to merge.
Step 4: As soon as you select the cells to merge, the “Merge” button will automatically appear on the toolbar at the bottom right of the screen. You just need to tap it, and it will automatically merge all the selected cells.
Leave a Reply