Microsoft Office Tutorials and References
In Depth Information
Getting Oriented
Indents can bring about some rather unusual visual results. If I select a right indent and type 10 in the
indent field, I can wind up with something like this (Figure 4–46):
Figure 4–46. Cell-dom used: the indent option
Don’t be fooled—the text is actually “in” the cell selected by the cell pointer. This can’t ha ppe n
with a number, however, and for a reason we’ve already discussed in the chapter on data entry; Excel
won’t allow a number to creep into another cell. Thus, if I type 43 in the very cell you see above with
the same indent settings, this is what I’ll get (Figure 4–47):
Figure 4–47. An indented number
Here the indent carries out what’s tantamount to an Auto Fit. The number is indeed indented, but
only within its own cell. Yeah—you’re not likely to use this very often. The two indent buttons (Figure
4–48) found on the Alignment Group on the Home tab of the ribbon:
Figure 4–48. The Indent buttons
equate respectively with the Right and Left Indent options in the Alignment Dialog box—but look at
the buttons. What I’m calling Right Indent features an arrow pointing left , and what I’ve called Left
Indent bears an arrow pointing right Nevertheless that’s what they are. Moreover, the Alignment .
Group caption clinging to the first of the two buttons above (seen when you rest you mouse over it)
calls it Decrease Indent , an d n ot Ri g ht In de n t; an d the othe r button i s l abe l e d Increase Indent ; an d
Search JabSto ::

Custom Search