Microsoft Office Tutorials and References
In Depth Information
The next two buttons are titled Decrease Indent and Increase Indent, respectively, and all
they do is push data in their cells slightly to the left or right by small increments, much in
the way that the indent option works in Word. Each click advances or pulls back the
data a bit more in their cells. Between you and me, I don’t recall ever having used these
buttons in an actual worksheet—but they’re there (see Figure 5–32).
Figure 5–32. The Indent buttons
The next button, Wrap Text, is a good deal more useful. Clicking Wrap Text is the option of
choice when you enter text in a cell that extends beyond its current column width and
you don’t want to widen the column. We’ve seen this problem before, of course, but
Wrap Text proposes a different solution:
Enter the phrase shown in
Figure 5–33 in cell B19.
Figure 5–33. Getting carried away: Too much text
Click back in cell B19 and click Wrap
Text. You’ll see what’s shown in
Figure 5–34. Back where it all belongs
Wrap Text treats the current column width as a fixed margin and heightens the row
instead, in order to confine the text within that margin. Wrap Text is thus an option you’ll
turn to if you need to maintain a column’s width as it presently stands.