How to merge cells in Google Sheets

When working on Google Sheets or Excel, the operations performed with tables, with cells in tables are basic operations and necessary for fast processing of content. And in the process of performing cell merging is a frequently used operation, which makes it easier to present the content. For example, when you create the title of a worksheet, or the title of a column in a table, you need to merge cells to write a title, put the title in the middle of the new cell to ensure the layout and rules when working tables in Google Sheets.

Manipulating cells in a sheet is as simple as merging multiple cells into one cell in Excel. The following article will guide you how to combine cells in Google Sheets.

1. How to link data between spreadsheets in Google Sheets
2. How to color alternating lines in Google Sheets
3. How to add or delete rows and columns in Google Sheets
4. How to insert checkboxes in Google Sheets

Instructions to merge cells in Google Sheets

Video tutorial for merging cells in Google Sheets

Step 1:

We draw tables in Google Sheets as usual. Next, highlight the cells you want to merge, then click Format , then select Merge cells below.

How to merge cells in Google Sheets Picture 1

Step 2:

This will display the option to merge cells depending on the cell that the user is processing.

1. Merge all: Merge all cells into one cell by selection, horizontally and vertically.
2. Merge horizontally: Merge selected cells into a row of cells.
3. Merge vertically: Merge selected cells into a column of selected cells.

The list of options displayed depends on the location that we want to merge, for example if we want to merge cells horizontally, there is no option to Merge cells vertically.

How to merge cells in Google Sheets Picture 2

Step 3:

The selected cell result is merged into a single cell. Note that when combining cells, the text content in the leftmost cell is retained and the content of other cells will be deleted.

How to merge cells in Google Sheets Picture 3

Step 4:

We now proceed to re-align the content in the merged cell, as the text is skewed to the left. Highlight the text in the merged cell, then click the horizontal icon in the toolbar and then click the center icon .

How to merge cells in Google Sheets Picture 4

As a result, the text has been pushed to the center of the cell.

How to merge cells in Google Sheets Picture 5

Step 5:

In case the user does not want to merge cells anymore , wants to separate cells as the original, it is also highlighted, click Format select Merge cells , then select Cancel merge .

How to merge cells in Google Sheets Picture 6

The result of the cells has been split back as before.

How to merge cells in Google Sheets Picture 7

With just a few basic operations, the process of merging or splitting cells in Google Sheets has been done. When you finish merging, you need to align the text to the center to ensure the layout of the table.

I wish you successful implementation!