Watch Video – Merge Cells In Google Sheets
In some cases, you would have a need to merge some cells and combine these together to make one single cell. These could be either merging cells in rows or columns (or both).
One practical example of this is when you have a header that has is the same for multiple columns and you need to merge the cells to make the header look like one (as shown below).
In this tutorial, I will show you how to merge cells in Google Sheets (horizontally as well as vertically).
I will also cover some additional things you need to take care of when merging cells in Google Sheets.
So let’s get started!
Table of Contents
How to Merge Cells In Google Sheets
Suppose you have the dataset as shown below and you want to merge ṭhe header row that has the text “Store #”.
Below are the steps to merge these cells:
- Select the cells that you want to merge
- Click the Format option in the menu
- Click on Merge cells option
- In the options that appear, click on ‘Merge horizontally’
The above steps would merge the three cells and make them one.
Another way to access the merge options is thorough the toolbar. When you click on the ‘Merge cells’ icon, it will merge all the cells. And if you click on the drop-down icon next to it. it will show other options such as merge horizontally or vertically
Different Types of Merge Option in Google Sheets
If you followed the steps above, you would have already noticed that there are the following types of merge options:
- Merge all
- Merge horizontally
- Merge vertically
Let me quickly explain each of these options.
When you use the ‘Merge all’ option, it will merge all the cells and you will get the result which is one big merged cell (as shown below).
Note that this option only becomes available when you have selected a contiguous range of cells. If you select a non-contiguous range of cells, you would notice that this option is grayed out.
When you select more than one row and use this option, cells in each row would be merged (as shown below).
In case you have only selected the cells in one row, then Merge all and Merge horizontally would do the same thing.
When you select more than one column and use this option, cells in each column would be merged (as shown below):
In case you have only selected one column, then ‘Merge vertically’ and ‘Merge all’ would do the same thing.
Issues when merging cell in Google Sheets
While using merged cells, there are a few things you need to know.
Can’t Sort Columns with Merged Cells
The first issue with merge cells is ṭhat you can not sort a column that has merged cells.
If you try and do that, it will give you an error as shown below.
Copies merged cells and not the value
If you have three cells merged together with some text in it and you copy and paste this somewhere else in the worksheet, the result would be merged cells (with the same text and formatting).
In case you only want to copy and paste the content of the merged cells and not get the result which itself are merged cells, you need to copy and then paste as value.
So there are few issues you need to keep in mind when working with merged cells in Google Sheets.
And in case you need to unmerge cells, you can easily do that. Simply select the cells that are merged, go to the Format –> Merged cells and then click on Unmerge.
So this is how you can easily merge cells in Google Sheets.
I hope you found this tutorial useful!
Other Google Sheets tutorials you may find useful:
- How to Lock Cells in Google Sheets
- How to Split Cell in Google Sheets (into separate columns)
- How to Combine Cells in Google Sheets (using simple Formulas)
- How to Group Rows & Columns In Google Sheets
- How to Separate First and Last Name in Google Sheets
- How to Compare Two Columns in Google Sheets
- How To Make Text Vertical In Google Sheets (Rotate Text)