You may come across some worksheet layouts that would benefit from having text displayed vertically instead of horizontally. For example, say you have created a reference table and one row label caption could apply to many adjacent rows. You can save space and make the table easier to read by merging the label cells into one narrow, tall cell and then displaying the caption text vertically. To display such text, select the cell with text you want to make vertical, go to the Home tab and click on the Orientation button in the Alignment group. From the resulting dropdown list, choose Vertical Text. The result will look as follows.
The same effect can be achieved by selecting the cell with the text you would like to make vertical, clicking the right mouse button, selecting Format Cells from the list of options and then selecting the Alignment tab, displaying the following window:
From within the Orientation box, you can either select the box with the vertical text to achieve the same orientation as in the previous screen, or pick the desired angle from the larger box to the right, which can yield various angles for your text. In this case I have picked an angle of 65 degrees, which will yield a text angle as shown below: