In this article:

How to Use Vertical Align in Google Sheets (2024 Update)

November 8, 2024

How to Use Vertical Align in Google Sheets

Using vertical alignment in Google Sheets allows you to position the content of a cell along the vertical axis: top, middle, or bottom. Here's how you can adjust the vertical alignment of cell content in Google Sheets:

Step 1: Select the Cells

Click and drag to select the cells that you want to center vertically. 

Step 2: Click the Vertical Align Button

In the toolbar above the spreadsheet, find and click the "Vertical align" button. 

Select one of the options:

  • Top align: Aligns your content to the top of the cell.
  • Middle align: Centers your content vertically within the cell.
  • Bottom align: Aligns your content to the bottom of the cell.
google sheets vertical align
vertical align google sheets

Step 3: Choose the Middle Option

After selecting your desired vertical alignment, the content of the selected cell(s) will adjust accordingly.

For more precise control, you can also use the "Format" menu at the top of the screen:

Go to Format > Alignment, and then select your desired alignment (top, middle, or bottom).

vertical align in google sheets

Example 

Suppose we want to vertically center the text in A1.

vertical alignment in google sheets

To do this, we'll select the "Middle" option.

vertical align text in google sheets

The text should now be vertically centered within the cell. 

google sheets vertical align text

We hope that this article has helped you and given you a better understanding of how to use vertical align in Google Sheets. If you enjoyed this article, you might also like our articles on how to make a Venn diagram in Google Sheets and how to perform string interpolation in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->