Watch Video – How to Merge Cells In Google Sheets (How to Combine Columns in Google Sheets)
When you work with data that has headers, sometimes, you may feel like you need to learn how to merge cells in Google Sheets.
For example, if you have the main header as Revenue and subheaders as 2016, 2017, and 2018, you can merge the three cells that make up the revenue header.
Something like shown below:
As you can see in the example above, Revenue spans across three cells that have been not beem merged.
How to Merge Cells In Google Sheets
Here are the steps for merging cells in Google Sheets:
- Select the cells that you want to merge.
- Go to the Format tab and within the Google Spreadsheet Merge Cells options select Merge All.
This would instantly combine two cells in Google Sheets, it’s also how to merge two columns in Google Sheets, and how to merge rows in Google Sheets.
Note: When you merge cells, it only retains the value in the top left cell. If there is anything in cells apart from the top left cells, Google Sheets shows you the prompt as shown below.
Note: Instead of navigating to the menu you can use the shortcut in the toolbar as shown in the following screenshot:
Now also have a look at the merge cells options available in Google Sheet:
- Merge All: This would merge all the selected cells and make them one. Note that you can only have contiguous cells that can be combined. If you have non-contiguous cells, merge options will not be available to use.
- Merge Horizontally: This would merge all the horizontal cells into one. Even when you select more than one row of cells, it will only merge the horizontal cells.
- Merge Vertically: This would merge all the vertical cells into one. Even when you select more than one column of cells, it will only merge the vertical cells.
Steps to Unmerge Cells in Google Sheets
Here are the steps to unmerge cells in Google Sheets:
- Select the merged cells that you want to unmerge.
- Go to the Format tab and within the Merge cells options select Unmerge.
This would instantly unmerge all the merged cells in Google Sheets.
How To Merge Cells In Google Sheets FAQ and Extra Tips
How to Combine Two Columns In Google Sheets
All you have to do to combine 2 columns into 1 in Google Sheets is use the merge vertically option from the merge menu. To merge rows you just have to use the merge horizontally option.
Is There a Shortcut to Merge Cells in Google Sheets?
There is no direct shortcut to merge cells. However, you can use keyboard shortcuts to open up the merge menu which is almost as quick. You just have to press Alt+O >M on windows or Control+Option+O > M on MacOS.
How Do I Merge Cells in the Mobile Version of Google Sheets?
- Select the cells you wish to merge by tapping and dragging or pulling the edge of the blue highlight box to cover all the cells.
- Click the merge cells button
Is There a Way to Merge Cells In Google Sheets Without Losing Data?
There is no solution to merge cells without losing data with the Google Sheets merge cells native function. However, you can install an add-on that will allow you to do this.
- Download and install Merge Cells
- Highlight the cells you want to merge
- Go to Extensions>Add-ons>Merge Cells
- Select how you want your data to combine from the available options
Why Can’t I Merge Cells In Google Sheets?
One of the main reasons you can’t merge cells is because they’re locked. You’ll need administrator rights on the spreadsheet to be able to unlock them.
Can I Copy Merged Cells Without Copying Their Formatting?
No, unfortunately, you can’t. It’s a bit of a bother in Google Sheets. You’ll need to copy the text within the cell instead of the whole cell.
Also Read: How to Merge Cells in Excel.
How Do You Merge Cells in Google Sheets and Split?
You can use the SPLIT function after merging cells to split the data. We have a full guide on the split function here.
How Do I Merge Data From Multiple Sheets in Google Sheets?
You can use IMPORTRANGE to import data from several other sheets into one. Check out our IMPORTRANGE guide to learn more.
More to Learn
So this is how to merge cells in Google Sheets and even combine columns or rows easily.
I hope you found this tutorial useful! If you did, You May Also Like the Following Google Sheets Tutorials:
- Concatenate in Google Sheets – Combine Cells Using Formula.
- How to Split Text to Columns in Google Sheets.
- How to Quickly Transpose Data in Google Sheets.
- How to Compare Two Columns In Google Sheets
- How to Combine Formula and Text in Google Sheets