In this article:

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

May 8, 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.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->