Merge cells and choose how text appears

You can merge multiple cells into one larger cell in documents, spreadsheets, or presentations. You can also change the way your text appears in the cells of a spreadsheet.

Combine or split cells

Merge cells in a spreadsheet

Combining cells is a good way to create titles or headings in a spreadsheet, or to put information from several cells into one.

Merge cells

  1. Open your spreadsheet.
  2. Select the cells you want to merge.
  3. In the toolbar at the top, click the merge icon . You can also choose from the following options by clicking the drop-down arrow next to the icon:
    • Merge all: Combines all selected cells into one cell.
    • Merge cells horizontally: Combines the cells in each selected row.
    • Merge cells vertically: Combines the cells in each selected column.

Unmerge cells

To unmerge a selected range of cells, click the merge icon in the toolbar, or click the arrow to the right of the icon and select Unmerge.

Merge cells in a document or presentation

You can combine or split the cells of a table in a document or a presentation.

Merge cells

  1. Open a document or presentation.
  2. Highlight the cells of a table that you want to combine.
  3. Open the Table menu.
  4. Select Merge cells.

Unmerge cells

  1. Open a document or presentation.
  2. Highlight the cells of a table that you want to unmerge.
  3. Open the Table menu.
  4. Select Unmerge cells.

Choose how to display cell text

In a spreadsheet, you can clip, wrap, or overflow the text in a cell.

  1. Open a spreadsheet and highlight the cells with text you want to change.
  2. Click the Format menu.
  3. Hover over Text wrapping.
  4. From the options, choose to wrap, clip, or overflow your text. The options are also available using the following icons in the toolbar:
    • Overflow : Text longer than its cell will continue into the cell next to it if it's empty.
    • Wrap : Text longer than its cell will break onto a second line of the cell.
    • Clip : Text longer than its cell will be hidden in order to fit.
  5. The cells you select will automatically adjust the text.

Note: If you don't see a checkmark in the bottom right of your spreadsheet, you're using an old version of Google Sheets, and text within a cell is wrapped by default. To turn text wrapping on and off, click the wrap text icon .

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

How helpful is this article:

Feedback recorded. Thanks!
  • Not at all helpful
  • Not very helpful
  • Somewhat helpful
  • Very helpful
  • Extremely helpful