How to Rotate Text in Google Sheets (in less than 5 seconds)

Google Sheets has some great data formatting tools. One such formatting feature is the ability to rotate text within a cell in Google Sheets.

Something as shown below:

Rotate Text in Google Sheets

Here are the two ways you can rotate text in Google Sheets:

  • Using the Toolbar
  • Using the Format Options

Using the Toolbar

Here are the steps to rotate text in Google Sheets using the toolbar:

  • Select the cells in which you want the text to be rotated.
  • In the Toolbar, click on the text rotation icon.
  • Select the text rotation option you want.

Rotate Text options in toolbar in Google shets

You can also specify the angle at which you want to text rotation done.

Using the Format Options

You can also use the Format options in the menu to rotate text in Google Sheets.

Here are the steps:

  • Select the cells in which you want the text to be rotated.
  • Click on the Format option in the menu.
  • Hover the mouse on the Text Rotation option.
  • Select from the options that appear.

Rotating Text in Google Sheets - Format Options

I prefer using the toolbar as it has a visual representation of how the text would look like.

You may also like the following Google Apps Tutorials:


10 Google Sheets Tips that will save you hours every week

Bar Sparkline in Google Sheets - rtl
Google Sheets

Sparkline in Google Sheets – The Only Guide You Need

Sparklines are miniature charts that you can create within a cell. These are quite useful when you’re creating a dashboard and want to quickly show a trend, seasonal increase or decrease, or outliers (maximum/minimum) visually. According

Google Sheets

How to Insert Timestamp in Google Sheets

Google Sheets is a great tool when you’re collaborating and working with people on the same sheet. It allows people to work in the sheet simultaneously. In this tutorial, you’ll learn various to insert timestamp in Google

Google Sheets Keyboard Shortcuts - Spreadsheets
Google Sheets

101 Google Sheets Keyboard Shortcuts

Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following and I see a lot of people migrating from other spreadsheets applications to Google Sheets.