How To Rotate Text In Google Sheets

Knowing how to rotate text in Google Sheets is useful if you want to change the rotation of the given data in a cell.

Meaning, for a better reader experience, we may need to make our text rotate to fit inside a cell with a narrow width.

We have covered most of the available options in the Text rotation feature of Google Sheets in our previous article regarding How to Make Text Vertical in Google Sheets.

In this article, we will be discussing the remaining options of rotating text in Google Sheets using the 2 convenient ways:

  • Toolbar – Text Rotation button
  • Format Menu – Text Rotation

The rule for rotating text in Google Sheets is as follows:

  • While the options in this article are also applicable for non-text values, they are preferably useful for labels, headers, or, text values.

Let’s take an example.

Ariane is creating a report of the number of books sold since January. See her table below:

How to Rotate Text in Google Sheets

She’s trying to keep her table compressed by giving her columns a width of 50. However, the labels, which are the months, are overlapping the size of the columns.

Instead of abbreviating the months or using smaller font size for these header titles, Ariane used the text rotation feature in Google Sheets to achieve her table requirements.

While the table rows adjust, her column width remains at 50 without compromising the text values in each cell.

Alternatively, she can use the Tilt down option of rotation text. See below:

How to Rotate Text in Google Sheets

Take a look at the different options that you can rotate your text using the custom angle option:

There are 13 predefined angle values already available. Nonetheless, you may still key in your preferred angle value for the rotation of your text ranging from -90 degrees to 90 degrees.

How to Rotate Text in Google Sheets

Watch out for a more advanced tutorial and examples on how you rotate text in the coming weeks. Be sure to subscribe to be notified. 

Awesome! Let’s begin getting to know more about the process and steps in rotating text in Google Sheets.

The Anatomy of Rotating Text in Google Sheets

The toolbar holds most of the commonly used features and functionality in Google Sheets. This is where we can find the text rotate options.

How to Rotate Text in Google Sheets

Alternatively, you may find them in the Format menu > Text Rotation

How to Rotate Text in Google Sheets

Using these easy-access menus and buttons in Google Sheet toolbar, you should be able to rotate texts conveniently.

 

A Real Example of Rotating Text

Take a look at our first example table below to see how to rotate text in Google Sheets:

The option used above is the Tilt up.

How to Rotate Text in Google Sheets

Notice how the labels were tilted up and the rows were adjusted to fit the text values in it while keeping the column width unchanged.

In the example below, the Tilt down option is used.

How to Rotate Text in Google Sheets

How to Rotate Text in Google Sheets

You can use either of the available options if you see fit. Just remember that our goal is to make our text easy to read and understand.

You may make a copy of the spreadsheet using the link I have attached below.

How to Rotate Text in Google Sheets

  1. Simply click the cells where you want to make the text vertical. In this case, I will be using the cell range A1:M1.

How to Rotate Text in Google Sheets

 

  1. Now, in the toolbar, click on the Text rotation icon.

 

  1. Finally, click on the Tilt up option.

How to Rotate Text in Google Sheets

 

  1. The texts in cell range A1:M1 now appear tilted up.

How to Rotate Text in Google Sheets

 

  1. Now, let’s try rotating text using the custom angle option. But first, let’s set the default rotation to our cell range by clicking None in the Text Rotation option.

 

 

  1. Click cell range A1:M1.

 

  1. In the Text Rotation button, click None.

 

  1. Text values in A1:H1 should revert to their original or default orientation.

How to Rotate Text in Google Sheets

 

  1. Now, let’s rotate text using the custom angle option.

 

 

  1. Click the cell range A1:M1. Click the custom angle option in the Text Rotation button.

How to Rotate Text in Google Sheets

 

  1. Type in -65 then hit Enter. Text values should now appear like the one below.

 

  1. Now, let’s rotate text to 45 degrees using the Format menu option.

 

 

  1. Click the cell range A1:M1. In the Format menu, find and click Text Rotation.

How to Rotate Text in Google Sheets

 

  1. Now, click the arrow in the Custom Angle option and click 45 degrees.

How to Rotate Text in Google Sheets

 

  1. The texts in cell range A1:M1 should now appear 45 degrees tilted up.

 

That’s pretty much it. You can now rotate text in Google Sheets together with the other numerous Google Sheets formulas to create even more powerful formulas that can make your life much easier.

 

Get emails from us about Google Sheets.

Our goal this year is to create lots of rich, bite-sized tutorials for Google Sheets users like you. If you liked this one, you'll love what we are working on! Readers receive ✨ early access ✨ to new content.

 

0 Shares:
Leave a Reply

Your email address will not be published.

You May Also Like