To be able to rotate the text in your worksheet as you work on it, it is best to click on the format cells dialog box in which it will feature the following options but in order to allow you to rotate, after having it clicked on, click and drag the alignment tab in which will allow you to rotate the text.