Search Images Maps Play YouTube News Gmail Drive More »
Sign in

Create, edit, and format

Merge cells

To merge cells horizontally or vertically in a spreadsheet, select the cells you'd like to merge and click the Merge icon in the toolbar.

From the Merge drop-down menu, select from the following options:

  • Select Merge all to merge all selected cells into one cell.
  • Select Merge cells horizontally to merge the cells in each selected row.
  • Select Merge cells vertically to merge the cells in each selected column.

If you'd like to unmerge a selected range of cells, select the merged cell(s) and click the Merge icon in toolbar.

Tell us how we're doing - Answer five short questions about your help center experience