Microsoft Office Tutorials and References
In Depth Information
Figure 4–44. The Alignment tab of the Format Cells dialog box
If you type a number in the Degrees field on the box’s right side and click OK, you can achieve that
48-degree angle, or any other tilt you want, at least between -90 and 90 degrees. You can also click on
the red diamond referenced by the arrow above, and drag it along that Orientation half-circle to angle
your text, too. Either way, you could get the example shown in Figure 4–45:
Figure 4–45. 48 degrees worth of text alignmnent
To turn this effect off—that is, to restore the data to a level orientation—return to the Degrees
field and type “0.”
And if you click that vertical Text field you see beneath the Orientation heading, that’s what you’ll
get—vertical text in their cells, as per the Vertical Text options we saw in the Orientation drop-down
menu in the Alignment Group.
On the left side of the Format Cells dialog are various Text alignment options. Now some of the
options in those Horizontal and Vertical drop-down menus are obscure, but here goes:
General —Brings about standard data alignment defaults, e.g., text is left-aligned, numbers
rightaligned. Obviously you’d only select this to restore realigned data to their original alignments.
Right and Left (Indent)— These simply push, or indent, data in their cells to the right or the left by
the number of characters you type in the Indent field in the dialog box. But just remember that if you
select a right indent, the text will move left , because it is the indent itself that pushes to the right.