Microsoft Office Tutorials and References
In Depth Information
Aligning text vertically
Interestingly, as you experiment with orientation, you won’t see a Horizontal option on
the Orientation button’s menu. This means that you need to use either the Format Cells
dialog box or the Undo command (Ctrl+Z) to restore cells to their default orientation.
Figure 9-48 Use the Orientation menu to rotate or stack text in a cell.
Excel automatically adjusts the height of the row to accommodate vertical orientation
unless you manually set the row height either before or after changing text orientation. Cell
G3 in Figure 9-47 shows what happens when you click the tall, skinny Text button on the
left side of the Orientation area. Although the button is labeled Text, you can also apply this
“stacked letters” effect to numbers and formulas.
You can use the angle controls to rotate text to any point in a 180-degree arc. You can use
either the Degrees box at the bottom or the large dial above it to adjust text rotation. To
use the dial, click and drag the Text pointer to the angle you want; the number of degrees
appears in the spinner below. You also can click the small up and down arrows in the
Degrees box to increment the angle one degree at a time from horizontal (zero), or you can
highlight the number displayed in the Degrees box and type a number from –90 through
90. Cells H3:K3 in Figure 9-47 show some examples of rotated text.