How to merge cells in Google Sheets

Google sheets allow users to either merge rows or column cells. If you need more space in Google Sheets, you can merge more than one cell to make a single cell. For example, you may need more than one cell to input a header representing more than one column. This article shall discuss some of the methods of merging cells in Google sheets.

Merging cells:

Using the Menu Bar

Here is the step to follow when using a computer to merge cells:

1. Open the Google sheet using the browser of your choice. That is, go to https://docs.google.com/ and log in using your email details.

2. Highlight the cells you want to merge.

3. Then, on the menu bar, locate and click on the format tab.


4. Hover the mouse on the merge cells button on the drop-down menu.

5. A side-view menu opens. Click either the Merge all, Merge Horizontally or Merge vertically.

When to use Merge all

Merge all features can be used to merge all cells selected. It can be used to merge cells either vertically or horizontally. It is the default merge button of Google Sheets. Steps to use this feature:

1. After hovering the mouse on the Merge cells button.

2. Click the Merge all button.

When to use Merge Horizontally feature

If your cells are in the horizontal direction (in one row), you can use the Merge horizontally button. Here are the steps to follow:

1. After hovering the mouse on the Merge cells button.

2. Click the Merge horizontally button.

When to use merge vertically feature

This feature is used in merging column cells. Here are the steps to follow:

1. After hovering the mouse on the Merge cells button.

2. Click the Merge vertically button.

Merging using the Tool Bar

In Google sheets, a toolbar is a section that contains several tool icons that can be used to modify the sheet. Here are the steps to follow when merging cells:

1. Open the Google sheet using the browser of your choice. That is, go to https://docs.google.com/ and log in using your email details.

2. Highlight the cells you want to merge.

3. Then, on the Toolbar section, locate the merging icon. You can click either the icon or the drop-down button.

4. The cells will be merged automatically if you click the merge button.

5. On the other side, if you click the on the drop-down menu, you will be prompted to select either;

  • Merge All
  • Merge Horizontally
  • Merge Vertically

Merging cells using Mobile Phone

Alternatively, you can use the Google sheet application to merge your sheet’s cells. Here are the steps to follow:

1. Download and install Google sheet App from the play store.

2. To open a new sheet, click the untitled spreadsheet.

3. Then, highlight the cells you want to merge.

4. Click the merge icon on the toolbar located at the bottom.

That’s all. All the selected cells will be merged.

Leave a Comment