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.
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.