In this article:

How to Rotate Text in Google Sheets (Easiest Way in 2024)

How to Rotate Text in Google Sheets

Follow the steps below to easily rotate text in Google Sheets. 

1. Open Google Sheets and Access Your Document

Open your browser, go to the Google Sheets website, and open the spreadsheet document where you intend to rotate text.

google sheets rotate text

2. Select the Cells Containing Text You Want to Rotate

Click on a single cell or click and drag to select multiple cells that contain the text you wish to rotate. Ensure your selection is precise to avoid rotating text unintentionally.

rotate text in google sheets

3. Navigate to Format > Text Rotation in the Menu Bar

In the Google Sheets menu bar at the top of the screen, click on "Format." From the dropdown menu, hover over "Rotation" to reveal the text rotation options. From the text rotation options, choose the one that best fits your needs. Options include rotating text up, down, or setting it vertically. Click on your chosen option to apply it to the selected cells.

how to rotate text in google sheets

Your rotated text should look like this.

rotate text google sheets

How to Merge and Rotate Text in Google Sheets

You can also merge and rotate text in Google Sheets. Simply follow the steps below

1. Open Your Desired Google Sheets Document

Navigate to the Google Sheets homepage, identify, and open the document where you need to merge and rotate text.

how to rotate text google sheets

2. Highlight the Cells You Plan to Merge for Combined Text

Select the cells you want to merge by clicking and dragging your mouse across them. Make sure all the cells that need to be combined are highlighted.

how to rotate text on google sheets

3. Merge Selected Cells via Format > Merge Cells > Merge All

Go to the "Format" menu on the top, select "Merge cells," and then choose "Merge all" from the sub-menu. This action will merge your selected cells into a single larger cell.

4. With Merged Cell Selected, Go to Format > Text Rotation

With the merged cell still selected, click on "Format" again, hover over "Rotation," and a side menu will appear with various rotation options. For our example, we will select "Rotate up".

5. Select Your Preferred Text Rotation for the Merged Cell and Adjust Cell Size

Choose how you want the text within the merged cell to be rotated. After selecting, you might need to adjust the size of the merged cell to accommodate the rotated text properly. Drag the cell's borders to resize it as needed.

We hope that you now have a better understanding of how to rotate text in Google Sheets. If you enjoyed this article, you might also like our article on how to filter Google Sheets without affecting other users or our article on Google Sheets emojis.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started