How to Merge Cells in Google Sheets

Merging cells...sounds like biology class!
Michael Michael (174)
0

Merging cells (or combining cells) in Google Sheets allows you to remove the separation of two or more cells. Merging cells is useful when you want to combine the cells of a row or column.

We'll show you how to merge two or more cells in Google Sheets.

Google WorkspaceGoogle Workspace ×1

Howchoo is reader-supported. When you buy through links on our site, we may earn a small affiliate commission at no cost to you.

highlight cells in google sheets

To highlight multiple cells in Google sheets, hold shift and click on the individual cells you want to merge. To select an entire row of cells, click on the corresponding letter at the top of the spreadsheet.

The selected cells will be the ones you will merge.

Merge all cells Google Docs

To merge the cells in Google Docs:

  • Go to Format.
  • Choose Merge cells.
  • Select Merge all to merge the selected cells.

You can also choose to merge them in specific directions, which is useful if you've selected both rows and columns.

To unmerge cells in Google Docs

  • Select the cell you want to unmerge.
  • Go to Format > Merge cells > Unmerge.
To create a drop-down list, you "group" the rows.
Michael Michael (174)
0

In Google Sheets, you create a drop-down list by "grouping" the rows of your spreadsheet.