How to Rotate Text in Google Sheets

There is no greater hope in human life than survival. At the same time, it is important to live well. With that in mind, every content on the website is written so that a person can get all the information from here to start his life to make beautifully.

According to that, Technology is one of the topics. It is also a part of life. Read carefully Details of Technology related article

How to Rotate Text in Google Sheets

It’s not always convenient to have text in a straight horizontal line in your spreadsheet. Whether you want to apply a slight angle or turn the text completely vertical, it’s easy to rotate text in Google Sheets.

Rotate Text in Google Sheets

You have two tools for rotating text in Google Sheets. You can use the button in the toolbar or a command from the menu. With each option, you can pick a simple tilt, rotate it vertically, or use an angle for the exact degrees of the turn.

RELATED: How to Rotate Text in Cells in Excel

Select the cell containing the text you want to rotate. You can also choose a group of cells, a column, or a row.

Select text to rotate

Click the Text Rotation button in the toolbar and choose from one of the five options. You can pick from tilt up or down, rotate up or down, or stack vertically.

Click Text Rotation in the toolbar

You can also click the arrow on the right to select a specific angle or enter the number of degrees for the angle in the box.

Enter the number of degrees

Alternatively, select Format > Rotation from the menu. You have the same options here to turn the text or pick an angle. The difference is that you cannot enter your own number of degrees for the angle from this spot.

Select Format, Rotation, and pick an option

Once you rotate your text, you can adjust the column or row size to make the turned text fit better.

Rotated column headers in Google Sheets

Merge Cells and Rotate Text

One particularly handy use for rotating text in Google Sheets is for row headers. You may have a group of rows that use the same label. You can make this look more appealing by merging the cells with the header and then rotating it.

RELATED: How to Group and Ungroup Rows and Columns in Google Sheets

Here we have a Number of Calls header that applies to five rows. We can merge the cells and turn the text for a better appearance.

Row headers to rotate

Select the cells you want to merge with one cell containing the text you want to rotate. Click Format > Merge Cells from the menu and choose “Merge All” or “Merge Vertically.”

Click Format, Merge, and choose an option

With the merged cell still selected, apply the rotation. Click the Text Rotation button in the toolbar and pick Rotate Up or select Format > Rotation > Rotate Up from the menu.

Click Format, Rotation, Rotate Up

Then as above, you can resize the column to fit the merged and rotated text nicely.

Merged and rotated row headers in Google Sheets

Whether you want to rotate column headers, row labels, or even random text, it can make your sheet look appealing and your data fit better. For more, take a look at how to wrap text in Google Sheets.

Did you like this article?
Share it on any of the following social media channels below to give us your vote. Your feedback helps us improve.

Other related Technologies ideas you might enjoy

Related Articles

Leave a Reply

Your email address will not be published.