How to Merge Cells in Google Sheets

Merging cells...sounds like biology class!
Michael Michael (175)
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.

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. As an Amazon Associate, we may earn a small affiliate commission at no cost to you when you buy through our links.

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.

Sheets calls this "protecting" cells.
Michael Michael (175)
0

Google calls locking cells—"protecting" cells. And it's really quite easy to lock a cell in Google Sheets. What does it mean to lock a cell in Google Sheets?