Microsoft Office Tutorials and References
In Depth Information
Working with Alignment and Spacing
Making Your Worksheet Look Good
Wrap Text button
Angle Clockwise: Angles the text in
the cell from left top to right bottom.
Vertical Text: Centers the text and
places one letter on top of the other.
Rotate Text Up: Places the text on the
lower-right side of the cell and runs it
vertically up the cell.
Rotate Text Down: Places the text on
the lower-left side of the cell and runs
it vertically down the cell.
A worksheet cell with wrapped text.
Shrink to Fit
Click the Alignment group Dialog Box
Launcher to open the Format Cells dialog
box where you can select a specific degree of
If you open the Format Cells dialog box, you
see a Shrink to Fit option on the Alignment
tab. This option allows Excel to automatically
change the font size in the selected cell to
force the data to fit within the cell’s current
width. Use caution with this option; the text
may become so small that it’s unreadable.
3. Choose an option. The selected cells take the
rotation you choose. In Figure 10-19, you see
heading cells angled counterclockwise.
Rotating Cell Text
Another feature you can use to dress up your
worksheet is to rotate the text. Rotating text is often
helpful for headings, but I wouldn’t recommend it for
your actual data. It can be a little difficult to read.
The following steps show you how to rotate text:
Select the cells you want to format.
2. Choose Home>Alignment>Orientation. A list
of options appears:
Angle Counterclockwise: Angles the
text in the cell from left bottom to
Rotating cell data to add a special effect.