How to rotate text in excel?

Posted on 06-02-2020 , by: admin , in , 0 Comments

Excel Version

122
Normal textRotated textRotated text name
TEXT 1TEXT 1Angle Counterclockwise
TEXT 2TEXT 2Angle Clockwise
TEXT 3TEXT 3Vertical Text

Problem :

I got straight text in Column 1 and need to rotate it.

Question :

How do I rotate the text?

Solution(step by step) :

Select cell that needs to be rotated.
In the Alignment group inside of Home tab click on the button with ab and arrow.
From the drop-down list, you will have few options. Choose the one that you need.
You will have every option described in the drop-down list.

If you need to remove rotation from the cell, select cell in which text is rotated.
In the Alignment group inside of Home tab click on the button with ab and arrow.
There will be highlighted rotation style.
Click on it again, and text rotation will be horizontal again.

Example:

In the Column 1 is normal (horizontal) text. Re-write it in the second column, and proceed with the rotation of text. Cell in the 1st row of the Column 2 needs to be Angle Counterclockwise Cell in the 2nd row of the Column 2 needs to be Angle Clockwise Cell in the 3rd row in the Column 2 needs to be Vertical Text
Column 1Column 2
TEXT 1 
TEXT 2 
TEXT 3 
share:

Leave a comment