Steps:
1) In the Excel sheet column you can type the text you want to Rotate.
2) Select the column and from the Home Tab click the Orientation button. It will dispaly all the text Roation options from the Orientation List. You can also right Click on the column and click on the Format Cells option and in the popup window you can the text rotation.
3) Now select the option which you need to align to the Text. The available options are Align Counterclockwise, Align Clockwise, Vertical Tex, Rotate Text Up and Rotate textdown.
4) Based on your selection the text is changed.
Please find the screen show below where for each option one sample is provided in the below secreen shot.
