Microsoft Office Tutorials and References
In Depth Information
Getting Oriented
Figure 4–59. Text, vertically jusftified
The three Text control options in the Alignment dialog box are variations on themes we’ve
pr e v i ousl y soun de d. As wi th Justi fy an d Di str i bute , Wrap text regards a cell’s current width as a
margin, and wraps cell text accordingly. The difference here is that Wrap text doesn’t try to flatten the
right text margin, but rather lets text advance unevenly against cell’s right boundary (Figure 4–60):
Figure 4–60. Wrapping and styling: text wrapped in its cell
Wrap text allows text to wrap naturally to the next line, and doesn’t try the spacing heroics of
Justify or Distribute; this command is represented by the Wrap Text button in the Alignment Group.
Those options—Wrap text, Justify, and Distribute—that realign text by raising row heights instead
of stretching column widths do serve a real purpose. They’re usefully applied to worksheets in which
you want to present data in a series of columns and maintain the same width for all of them, even as
the data in the columns exhibit various widths.
Shrink to fit is a curious flip side to the workings of Wrap text and column Auto Fit. Whereas Wrap
text tries to pile text into a cell without changing its width by raising its row height instead, and Auto Fit
tries to widen columns to accommodate all text in one cell, Shrink to fit changes neither col umn wi dth
nor row height; it shrinks text in order to gather it all into existing width and height. So if you start with
this (Figure 4–61):
 
Search JabSto ::




Custom Search