To rotate text, first select the cell or range of cells you want to rotate. (you can select a range by dragging the thick cross)

Once you have selected a cell or range, click Format on the menu bar and select Format->Cells, or, right click on any cell in the selected range and click on Format Cells in the drop down menu.

Both of these methods will invoke the format cells dialogue box. To rotate the text in the selected cells, put your mouse pointer on the red diamond in the orientation field. Hold your left mouse button down and drag the diamond to the degree that you need. If you want the text to be vertical in the cells, drag the diamond 90 degrees to the bottom of the orientation field.

You will notice two text alignment list boxes to the left of the orientation field. You can choose from Vertical list box, whether your text will be aligned with the top, bottom, or centre of the cell after the rotation.

Click the OK button after you make your selections.

Now the text labels are aligned vertically in the cells. You can decrease the width of the columns by dragging the column edge in the part of the column that separates the column index Letters.

Now you have vertical text in columns that are only as wide as they need to be to contain the data.