Chat with us, powered by LiveChat

How to Merge Cells in Google Sheets

How to Align and Merge Cells in Google Sheets

How to Merge Cells in Google Sheets

Using the alignment options makes it easier to read the text and data in a spreadsheet.

Change Horizontal Alignment

  1. Select a cell or cell range.
  2. Click the Horizontal align button
  3. Select an alignment option.
    How to change horizontal alignment in Google Sheets.

Change Vertical Alignment

You can also change a cell's vertical alignment.

  1. Select a cell or cell range.
  2. Click the Vertical align button.
  3. Select an alignment option.
    How to change vertical alignment in Google Sheets.
Cell Alignment Buttons Description
Left/Center/Right Align
Left Center Right
Align cell contents to the left side, center, or right side of the cell using these three buttons.
Text rotation
Text rotation
Align cell contents diagonally or vertically.
Text Wrapping
Text Wrapping
Make all cell contents visible by displaying them on multiple lines within the cell (this increases the row's height).
Merge cells
Merge cells
Select from a few options for merging cells together.

Wrap Text

You can also control how text wraps if the cell isn't wide enough to display it all.

  1. Select a cell or cell range.
  2. Click the Text wrapping button.

    There are three ways that text can wrap in a cell:

    • The first is for the text to overflow into the next cell.
    • You can also choose to wrap text into a second line.
    • Or, to just clip the text off at the cell border.

  3. Select a text wrapping option.
    How to wrap text in Google Sheets.

The text in the cell wraps around to a new line.

Merge Cells

You can also merge several cells together to display text across multiple columns or rows.

  1. Select a cell range.
  2. Click the Merge cells button.
    How to merge cells in Google Sheets.

The selected cells and merged into a single cell.

Unmerge Cells

If you need to separate the cells again, unmerging them works the same way.

  1. Select the merged cell.

    When the merged cell is selected, the Merge Cells button on the toolbar will be active.

  2. Click the Merge cells button.
    How to unmerge cells in Google Sheets.

The selected cells are split.

FREE Quick Reference

Click to Download