Take a look at our first example table below to see 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.
This is where we can find the text rotate options.Īlternatively, you may find them in the Format menu > Text Rotation
The toolbar holds most of the commonly used features and functionality in Google Sheets. The Anatomy of Rotating Text in Google Sheets Be sure to subscribe to be notified.Īwesome! Let’s begin getting to know more about the process and steps in rotating text in Google Sheets. Watch out for a more advanced tutorial and examples on how you rotate text in the coming weeks. Nonetheless, you may still key in your preferred angle value for the rotation of your text ranging from -90 degrees to 90 degrees. There are 13 predefined angle values already available. Take a look at the different options that you can rotate your text using the custom angle option: While the table rows adjust, her column width remains at 50 without compromising the text values in each cell.Īlternatively, she can use the Tilt down option of rotation text. 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. However, the labels, which are the months, are overlapping the size of the columns. She’s trying to keep her table compressed by giving her columns a width of 50. While the options in this article are also applicable for non-text values, they are preferably useful for labels, headers, or, text values.Īriane is creating a report of the number of books sold since January.The rule for rotating text in Google Sheets is as follows: In this article, we will be discussing the remaining options of rotating text in Google Sheets using the 2 convenient ways: 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. The Anatomy of Rotating Text in Google Sheets.