How to Merge and Unmerge cells in Google Sheets


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

  1. In your Google Sheet, select the cells that you want to merge.
  2. From the menu bar, click on format option.
  3. 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

  1. In your Google Sheet, select the cells that you want to merge.
  2. 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 :

  1. Open the Google Sheet in your mobile app.
  2. Select the cells that you want to merge.
  3. Click on the merge button available at the bottom in order to merge the cells.

To Unmerge cells

  1. Select the range that is to be unmerged
  2. From the menu bar, click on format option.
  3. Further click on merge cells option and from pop-up menu select unmerge option.

                                                                   OR

  1. From the toolbar, click on the drop down arrow beside merge cells icon.
  2. 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.

Harshita Mathur

My name is Harshita Mathur. I come from Jaipur, Rajasthan. I am a law student. Apart from this I am an amateur writer.

Recent Content