Last Updated on October 31, 2023 by Jake Sheridan
How To Make Text Vertical In Google Sheets
Have you ever wondered how to create vertical text in Google Sheets?
Vertical text can be useful if you need to save space in your spreadsheet or you might simply want to display text vertically for aesthetic purposes.
Google Sheets offers a lot of formatting tools to help you fully customize your spreadsheets.
One of the less-used formatting options that can still be very useful is the Vertical or Stacked Text formatting option.
Google Sheets Vertical Align (in 3 Steps)
Here’s how to apply it to cells in your spreadsheet:
Select the cell or cells you want to format with vertical text
Open the format menu, then hover over the Text Rotation submenu, then choose the Stack Vertically option
Your text will be formatted with the characters stacked vertically from top to bottom
But what if you don’t want your text to be vertical anymore…
Unstacking Text (Super Easy)
If you’re working in a spreadsheet with vertical text that you no longer want, follow these steps to remove the vertical formatting
Select the cell(s) you want to make horizontal
Open the format menu, then hover over the Text Rotation submenu, then choose the None option at the top
Your text will display horizontally again
How To Rotate Text In Google Sheets
Here’s how to rotate text in Google Sheets.
First, select the cell or range of cells you want to convert into vertical text.
In the example above, we have several row headers in the range B2:B13 that we want to display as vertical text.
Click on the Text Direction icon in the Google Sheets toolbar.
Select the Rotate up if you want the text to be read upwards.
The text formatting will automatically apply to the selected range.
This option is also a good way to label column headers as well since it allows you to display more information in a smaller space.
Users can also choose the Rotate down option if they want the text to be read going down.
The result is similar to the Rotate up option but rotated 180 degrees.
Users can also choose to stack letters vertically.
Each letter in the text will occupy a new line rather than being read as a single word.
If you want to convert the vertical text back into regular text, you can click on the None option to revert the applied formatting.
You may make a copy of this example spreadsheet to test it out on your own.
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to make text vertical in Google Sheets. Want more? Check out all the Google Sheets Tutorials.
More ways to use text in Google Sheets:
- Add Bullet Points
- Insert Text Box
- Insert Special Characters
- Insert Symbols
- Insert Page Break
- Center Text
- How To Make Text Fit In Cell
- Change Case
- View Page Breaks
- Line Break In Google Sheets
- How To Capitalize
- How To Wrap Text
- How To Indent
- Count Cells with Text
- Fit Text to Cell
- Checking if a Cell Contains a Substring
- TEXT Function
- Combine Text From Two Cells
- SUMIF Cells If Contains Text
- Add Text To Formula
- Indent Text
- Change Text To All Caps
- Spell Check in Google Sheets
- How to Use Spell Check
- Insert a Bullet List
- Make a Numbered List
- Insert Bullet Points
- Add a New Line In Cell
- Add Multiple Lines In One Cell
- Wrap Text In Cell
- Superscript In Google Sheets
- Make A Degree Symbol
- SUBSTITUTE Function
- How To Alphabetize