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.
   

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.
   

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.
   

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.
   

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.
   

The selected cells are split.