Microsoft Office Tutorials and References
In Depth Information
Aligning text vertically
6. Select all the active columns, and double-click any one of the lines between the
selected column headers (for example, the line between the column letters C and
D) to shrink all the columns to their smallest possible width.
Using the Angle Counterclockwise command on the Orientation button’s menu (in
the Alignment group on the Home tab) rotates the text to +45 degrees for you, but
because we wanted to apply borders and alignment options as well, using the Format
Cells dialog box was a more efficient method.
You’ll find the Angled Text.xlsx file with the other examples on the companion Web site.
For more about cell borders, see “Customizing borders” later in this chapter. For more about
row heights, see “Changing row heights” later in this chapter.
Shrinking text to it in cells
The Shrink To Fit check box on the Alignment tab in the Format Cells dialog box reduces
the size of the font in the selected cell until the contents can be completely displayed in the
cell. This is useful when you have a worksheet in which adjusting the column width to allow
a particular cell entry to be visible has undesirable effects on the rest of the worksheet or
where angled text, vertical text, and wrapped text aren’t feasible solutions. In Figure 9-49,
we typed the same text in cells A1 and A2 (and increased the font size for readability) and
applied the Shrink To Fit option to cell A2.
Figure 9-49 The Shrink To Fit alignment option reduces the font size until the cell contents it
within the cell.