Combining two or more cells in a sheet is a very practice done for creating a title that can be fabricated using the contents of multiple cells. Thus to perform this task in google sheets, here are some ways.
Through menu bar
- In your Google Sheet, select the cells that you want to merge.
- From the menu bar, click on format option.
- From the further options available, click on merge and then choose the way in which you want to merge your cells – merge horizontally, merge vertically or merge all.
Short method
- In your Google Sheet, select the cells that you want to merge.
- To complete the action, click on merge button present on the tool bar.

Using a formula
The syntax for the merge formula is :
=CONCATENATE(string1, string2….)
Here, string1 is the first cell to which you want to merge other cell.
String2 is that other cell that gets merged with initial cell.
For example – =CONCATENATE(A2,B2,C2)
Google Sheets also can mere ranges and for that the proposed formula is :
=CONCATENATE(string1 : string2)
here, string1 stands for the first cell of the range and,
string2 stands for the last cell of the range to be merged.
For example : = CONCATENATE(A1 : F2)
These were the ways through which cells can be merged in Google Sheets on a desktop or a laptop. But the interesting fact is that same can be done in mobile too. This can be done by :
- Open the Google Sheet in your mobile app.
- Select the cells that you want to merge.
- Click on the merge button available at the bottom in order to merge the cells.
To Unmerge cells –
- Select the range that is to be unmerged
- From the menu bar, click on format option.
- Further click on merge cells option and from pop-up menu select unmerge option.
OR
- From the toolbar, click on the drop down arrow beside merge cells icon.
- Click on unmerge option and your work is done.
That’s it! Here we wrap up with getting aware about the easiest steps for merging and unmerging the cells in a Google Sheet.