How to Merge Cells in Google Sheets

Merging cells...sounds like biology class!
Michael Michael (179)

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.

It's also worth taking a moment to review the latest list of keyboard shortcuts in Google Sheets to help optimize your workflow.

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.

Once your cells are formatted, you may find our guide on how to get the sum of a column in Google Sheets.

Expand what you can do in Google Sheets!
Britt Britt (54)
1 minute

Google Sheets makes it easy to create data spreadsheets that can be used by a team of collaborators.