Arrow left
Back to product guides
Google Sheets Tips

How to Align Text in Google Sheets

In this article, you will learn how to align text in Google Sheets. There are two types of alignments in Google sheets - vertical and horizontal, with three patterns each, Top/Middle/Bottom and Left/Center/Righ. As you can apply both vertical and horizontal alignments in the same cell, there are nine patterns of text alignments. The picture below summarizes the nine combinations. Text alignment is beneficial when creating a neat and clear list or table. 

The nine types of text alignments in Google Sheets

How to align text horizontally in Google Sheets

There are three ways for horizontal alignment - shortcuts, toolbar, and menu bar.

With shortcuts

  1. Select the cells containing texts you need to line up.
  2. Press the shortcut keys as follows.
Shortcuts for text alignment

From the toolbar

If you don’t like using shortcuts, you can align text by clicking the alignment icon in the toolbar.

  1. Select the cells containing texts you need to line up.
  2. Go to the “Horizontal align” icon in the toolbar.
  3. Click the icon and select one of the patterns in the drop-down list.
How to align text horizontally from the toolbar in Google Sheets

From the menu bar 

  1. Select the cells containing texts you need to line up.
  2. Navigate to the “Format” tab.
  3. Go to “Alignment”.
  4. Choose one of the horizontal alignment patterns in the list.
How to align text from the menu bar in Google Sheets

How to do vertical text alignment in Google Sheets

There is no default shortcut key to align text vertically. Thus you need to do vertical alignment from the toolbar or menu bar.

From the toolbar

  1. Select the cells containing texts you need to line up.
  2. Navigate to the “Vertical align” icon in the toolbar.
  3. Click the icon and choose one of the patterns in the drop-down list.
How to do vertical alignment from the toolbar

From the menu bar 

  1. Select the range containing texts you need to line up.
  2. Go to the “Format” tab.
  3. Move to “Alignment”.
  4. Select one of the horizontal alignment patterns in the list.
How to do vertical alignment from the menu bar

What are the other tips on text in Google Sheets?

Check the following articles if you are interested in formatting text in cells.

How to Indent Texts in Google Sheets: Explained

How to Wrap Text in Cell in Google Sheets

How to Capitalize All Letters in Google Sheets

How to Make All Letters Lowercase in Google Sheets

How to Capitalize the First Letter in Google Sheets

Do you want to learn how to combine or split text in Google Sheets?

How to Combine Texts in Google Sheets

How to Use the CONCATENATE function in Google Sheets

How to Split Texts into Columns in Google Sheets

How to Use SPLIT Function in Google Sheets

Why don’t you double-check the spelling of your texts before printing or closing Google Sheets?

How to Spell-check in Google Sheets

Some of these tips or formulas related to text are useful when you create a financial summary or analysis with narratives, as you can see in each sheet in the following LiveFlow template, Turn Reports into Simple Narrative Template. Check LiveFlow if you want to learn more about automated financial templates.

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711