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 Rotate Text in Google Sheets

In this article, you will learn how to change the direction of text in Google Sheets.

Why do you rotate fonts in Google Sheets?

There are several reasons why you might want to rotate text in Google Sheets. Some possible reasons include the following:

  1. To make better use of space in a cell or on a sheet. For example, if you have a long text string that doesn't fit within the width of a cell, rotating the text can allow you to display the entire text string without having to widen the column.
  2. To improve the readability of the text. For example, if you have a long text string that is difficult to read when displayed horizontally, rotating the font can make it easier to read.
  3. To create a more visually appealing design for a sheet. For example, if you want to add some visual interest to a sheet, rotating text can help to break up the monotony of horizontally aligned text.

You should rotate text in Google Sheets whenever it helps you organize or present the information on your sheet.

How to change text direction in Google Sheets

Here are the steps you need to follow:

  1. Select the cell or cells where you want to change the text direction.
  2. Click the "Format" tab in the menu bar and go to the “Rotation” section, or directly navigate to the toolbar and click the “text rotation” icon.
  3. In the "rotation" menu, choose the desired text direction. There are six types of rotations,  including the default setting and a dropdown menu to customize the degree of the rotation.
Change the direction of texts
How to change the direction of texts from the menu bar or toolbar in Google Sheets

The text in the selected cell or cells should now be rotated to the angle you specified. If you want to undo this change, you can simply repeat these steps and set the rotation angle back to 0 degrees.

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: [email protected]

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.