LiveFlow raises $13.5 million Series A led by New York-based Valar Ventures and launches LiveFlow Next to revolutionize accounting!
Read More
Arrow
Back to 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. 

How to Align Text in
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.
Google Sheets
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.
From the toolbar
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.
Alignment
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.
Alignment
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.
Alignment
How to do vertical alignment from the menu bar

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

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how!

Get personal help

We guarantee you personal help on chat or Zoom within maximum 6 hours between 9am and 10pm EST.
Blue Tick
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below

Supercharge your financial reporting today

See LiveFlow in action and discover how to streamline your workflows.