How To Merge Rows In Google Sheets

In this tutorial, you will learn how to merge rows in Google Sheets.

Quick Navigation

When working with your data, you may want to merge multiple cells into a single cell.

For example, you may have a Google Sheets report that keeps track of monthly revenue data. In this report, each month will have its own column header.

You would like to add another header on top of each month to indicate the year.

Cells that span multiple cells can help improve the look of your spreadsheet and may make your tables easier to understand.

How To Combine Multiple Rows Together in Google Sheets

Here’s how to combine multiple rows together in Google Sheets:

Step 1

First, click on the row header of the row you want to merge into a single cell. In this example, we’ll use row 4 in our spreadsheet.

Step 2

Next, hover over the Format menu and look for the Merge cells option. Select the Merge all option in the Merge cells submenu.

Step 3

Google Sheets will warn the user that merging cells will only preserve the top-leftmost value of the range. Click on OK to proceed.

Step 4

Your chosen row should now be merged into a single cell.

To reference this cell, we will have to use the cell reference of the top-leftmost cell. In this instance, our merged cell can be referenced using the formula =A4.

Step 5

Next, we will try to merge multiple rows horizontally. Select the range of rows you would like to convert into merged rows.

Step 6

We can click on the arrow next to the Merge cells icon to reveal all possible options. In this case, we will select the Merge horizontally option.