How to Vertically Align Text in a Cell or Group of Cells in Google Sheets

The value in a cell, whether it is a number, a string, a date, or special characters, is placed at the bottom of the cell by default. There are two ways to vertically align text in a cell or cell range in Google Sheets. It applies to numbers, dates, times, or any value.

Google Sheets is an advanced web-based spreadsheet solution that is relatively easy to use. However, it can sometimes take time to find all of the available features, especially if you are familiar with Excel. This post will show you how to vertically align text in a cell in Google Sheets.

Toolbar Icon to Vertically Align Text in a Cell in Google Sheets

Vertical alignment of text is possible using a small icon on the quick access toolbar. See how text is aligned in action.

To vertically align text in a cell, first, select the cell or cell range that you want to modify. Then, click on the “Vertical align” icon in the quick access toolbar. A drop-down menu will appear with the following options:

  • Top: This will align the cell content at the top of the cell.
  • Middle: This will align the cell content in the middle of the cell.
  • Bottom: This will align the cell content at the bottom of the cell.
Toolbar icon to vertically align text in Sheets

Menu Command to Vertically Align Text in a Cell in Google Sheets

You can also use the menu command Format > Alignment to vertically align text.

There are six options under the menu: Left, Center, Right, Top, Middle, and Bottom. Select Top, Middle, or Bottom for vertical alignment. The other three options are for horizontal alignment.

First, select the cell or cells that you want to format, and then choose one of the above options.

How to vertically align text in a cell in Docs Sheets

New Line in Cells:

If you want to make a new line in a cell, you can do it by using the shortcut key Alt+Enter. Here is the detail: How to Move New Lines in a Cell to Columns in Google Sheets.

Text Rotation in Sheets:

To rotate text, you can use the text rotation icon next to the text wrapping in the quick access toolbar or the menu Format > Rotation.

You can rotate text by custom angles, such as 25° or 40°. You can also use predefined styles in text rotation, such as tilt-up, tilt-down, stack vertically, rotate up, and rotate down.

Rotate text or values in a cell in Sheets

I hope you found these quick Google Sheets tips helpful.

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Lookup Values Under Categories in Excel and Google Sheets

We can use a combination of XLOOKUP and VLOOKUP in both Excel and Google...

Extract Items Under a Category from the Same Column in Excel

In Excel, you can use a combination of the XLOOKUP and DROP functions to...

How to Create a Searchable Table in Excel Using the FILTER Function

Finding specific records, or rows containing the required information, is straightforward in Excel using...

Time Sequences in Excel by Minute, Hour, or Second Increments

Creating time sequences, whether by hour, minute, or second increments in Excel, can be...

More like this

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

Limit Formula Expansion to a Specific Row in Google Sheets

In this tutorial, I’ll explain how to limit the expansion of an array formula...

3-D Referencing Structured Data Tables in Google Sheets

When you have several tables within a single sheet—not across multiple sheets in a...

1 COMMENT

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.