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.
   

Cell Alignment Buttons	Description
Left/Center/Right Align	Align cell contents to the left side, center, or right side of the cell using these three buttons.
Text rotation	Align cell contents diagonally or vertically.
Text Wrapping	Make all cell contents visible by displaying them on multiple lines within the cell (this increases the row's height).
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.
   

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

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.