Live Traffic Feed

Thursday, August 18, 2016

How to fit the text in narrow Columns of Excel or how to change the Orientation of the text?

Suppose the text in excel cell is big and you don't want to increase Column width and want to show the labels vertically or diagnolly?

The below are different options available for changing the Orientation of text in an excel cell.

Angle Counterclockwise
Angle Clockwise
Vertical Text
Rotate Text Up
Rotate Text Down
Format Cell Alignment

To change the orientation of excel cell you need to select the excel cell of text and select the option of orientation.

By default if the text length exceeds Column width then the text overlaps with next Column and it looks as below.




Suppose you choose the option of "Angle Counterclockwise" option and the display of text in excel cell is as below in counterclockwise direction.



If you choose the option of "Angle Clockwise" 



If you choose the option of  "Vertical Text" 


If you choose the option of  "Rotate Text Up" 



If you choose the option of  "Rotate Text Down" 




The last option of  "Format Cell Alignment" take you through the below screen. In the below screen you only worry about Orientation for now. Going forward we can learn other options in the below screen.

For Orientation you can choose Positive or Negative angle based on the direction of text you want to fit the text in excel cell.

The Up and Down arrows in below Increase the angle and decrease the angle. Other way is click on text direction pointer below and drag Up or Down based on increase or decrease of angle.




Text direction can be "Right-to-Left" or "Left-to-Right" based on your choice.













No comments: