Displaying text vertically in a cell (Excel 2000/ 2002/ 2003/ 2007)

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 complex 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 appropriate cell and choose Format | Cells from the menu bar. Then, switch to the Alignment tab. Finally, click on the preview text box on the left side of the Orientation panel and click OK.

In Excel 2007, 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.