Microsoft Office Tutorials and References
In Depth Information
Aligning text vertically
A cool application of angled text
Many times the label at the top of a column is much wider than the data stored in it.
You can use the Wrap Text option to make a multiple-word label narrower, but
sometimes that’s not enough. Vertical text is an option, but it can be difficult to read and
takes a lot of vertical space. Try using rotated text and cell borders:
Here’s how to do it:
1. Select the cells you want to format, and click the dialog box launcher in the Font
group on the Home tab to display the Format Cells dialog box.
2. Click the Border tab, and apply vertical borders to the left, right, and middle of the
3. Click the Alignment tab, and use the Orientation controls to select the angle you
want. (It’s usually best to select a positive angle from 30 to 60 degrees.)
4. In the Horizontal Text Alignment drop-down list, select Center and then click OK.
Excel rotates the left and right borders along with the text.
5. Drag down the bottom border of the row 1 header (the line between 1 and 2) to
make it deep enough to accommodate the labels without wrapping.