In this tutorial, you will learn how to merge rows in Google Sheets.
How To Merge Rows In Google Sheets
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:
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.
Next, hover over the Format menu and look for the Merge cells option. Select the Merge all option in the Merge cells submenu.
Google Sheets will warn the user that merging cells will only preserve the top-leftmost value of the range. Click on OK to proceed.
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.
Next, we will try to merge multiple rows horizontally. Select the range of rows you would like to convert into merged rows.
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.
Each row should now be merged horizontally.
What should you do if you need to unmerge a cell?
First, select the cell you wish to unmerge. Then click on the Unmerge option under the Merge cells drop-down menu.
Your merged cell should now be converted into an unmerged range of cells.
Do note that only the top-leftmost value will be retained after merging and unmerging a range of cells.
This guide should explain everything you need to know about merging rows in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More ways to use rows in Google Sheets:
- Move A Row
- Delete Empty Rows
- Group Rows
- Change Row Height
- Number Rows
- Make A Row Float
- How Many Rows Can Google Sheets Handle?
- Add A Row
- Highlight A Row
- Insert Multiple Rows
- Delete Every Other Row
- Delete Rows
- Alternate Row Colors
- Highlight Row Based On Cell
- Select Multiple Rows
- Sum A Row
- Sort Rows
- Resize Rows
- Remove Duplicate Rows
- Switch Rows
- Select Every Other Row
- Duplicate Rows