Formatting Cells

In Google Sheets formatting cells can be done in a number of ways. Learn all about formatting in Google Sheets here.

Text alignment

By default, any text entered into your spreadsheet will be aligned to the bottom-left of a cell. Any numbers will be aligned to the bottom-right of a cell. Changing the alignment of your cell content allows you to choose where the content will appear.

To modify the horizontal text alignment:

  1. Select the text you want to modify.
    Clicking the Align button
  2. Click the Horizontal align button in the toolbar, then select the desired alignment from the drop-down menu.
    Choosing the horizontal alignment
  3. The text will realign.
    The new horizontal alignment

To modify the vertical text alignment:

  1. Select the text you want to modify.
  2. Click the Vertical align button in the toolbar, then choose the desired alignment from the drop-down menu.
    Choosing the vertical alignment
  3. The text will realign.
    The new vertical alignment

You can apply both vertical and horizontal alignment settings to any cell.