How to rotate text in excel?

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

How to rotate text in excel?

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.

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

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 1 Column 2
TEXT 1
TEXT 2
TEXT 3

Leave a comment