How to Merge Cells in Google Sheets

Learn how to merge cells in Google Sheets in 4 simple steps, how to un-merge cells and other merging options available.

If you’ve ever worked with sheets that have headings and subheadings, you’ve probably wondered how to merge cells in Google Sheets in order to get the most appealing appearance. No one want’s an ugly spreadsheet.

How to Merge Cells in Google Sheets

The easiest way is to learn by doing:

Let’s say you have one main header (2019) and six subheaders (January, February, March, April, May, and June). If you want your main heading to span across several adjacent cells (as shown in the example below), you must first merge them.

Merging Cells in Google Sheets in 4 steps

  1. First, you’ll have to select the cells that you want to merge.
  2. Then, you should left click on the Format tab and choose Merge Cells from the drop-down menu, or click on the Merge button in your toolbar.
  3. There you’ll see different options you can use to merge cells – Merge all, Merge horizontally or Merge vertically depending on the cells that you’ve selected. (PSSST. If some cells that you selected had already been merged, the Unmerge option will also be available for you to use.)
  4. Choose one of the merge options mentioned above, and that’s it! All selected cells will be instantly merged according to the option you had selected.

Merge Cells Options Available in Google Sheets

When merging cells in Google Sheets, there are three different options:

  1. Merge all – Use this option for merging contiguous cells into one (if you select non-contiguous cells, this option will not be available for you to use).
  2. Merge horizontally – Use this option for merging horizontal cells into one (even if you select cells across two or more rows, it will only merge the horizontal ones).
  3. Merge vertically – Use this option for merging vertical cells into one (even if you select cells across two or more columns, it will only merge the vertical ones).

However, keep in mind that when you merge several different cells into one, the merged cell will retain the value only from the top left cell. If there were any data in cells apart from this one, you’ll see the same prompt that’s shown below.

Unmerging Cells in Google Sheets

If you no longer want your cells to be merged, you can easily unmerge them.

  1. First, you’ll have to select the cells that you want to unmerge.
  2. Then, you should left click on the Format tab and choose Merge Cells from the drop-down menu, or click on the Merge button in your toolbar.
  3. There you’ll see the Unmerge option. Click on it and all the selected cells will be instantly unmerged.

Want access to *cool* new sheets templates?

Join the newsletter right now.

Sign up to get notified when new Google Sheets templates + tools get added to the directory.

We send x2 emails per month. No spam. Dancing not a requirement.