Merge cells and wrap text

You can combine cells together in documents, spreadsheets, or presentations by merging them. You can also wrap text in a spreadsheet so that you can see all the text inside a cell.

Merge cells

It is possible to combine cells in spreadsheets, documents, and presentations.

Merging and unmerging cells in a spreadsheet

To combine cells horizontally and/or vertically in a spreadsheet:

  1. Highlight the cells you want to combine.
  2. In the toolbar, click the merge icon .

From the Merge drop-down menu, you can 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.

To unmerge a selected range of cells:

  1. Highlight the cells you want to unmerge.
  2. In the toolbar, click the merge icon .
  3. Click the arrow to the right of the icon > select Unmerge.
Merging and unmerging cells in a document or presentation

To combine cells in a table of a document or presentation:

  1. Highlight the cells of a table that you want to merge.
  2. Open the Table menu.
  3. Select Merge cells.
  4. To unmerge the cells, open the Table menu > choose Unmerge cells.

Wrap text

In a spreadsheet, text that is longer than its cell will overflow into the cell next to it if it's empty, making the full text visible. If the adjoining cells are already full, your text will be clipped off in order to fit. However, if you wish to make it visible, you can wrap the text.

If you want the text in the cell to wrap onto a second line in the cell:

  1. Select the cell.
  2. In the toolbar, click the wrap text icon wrap text.
  3. Clicking the icon again will turn text wrapping off.
See an example of text wrapping
If you are using the old version of Google Sheets, text within a cell is wrapped by default. Turning text wrapping on and off is done the same way in both versions of Sheets.

Matt is a Docs & Drive expert and author of this help page. Leave him feedback below about the page.

Was this article helpful?