Microsoft Office Tutorials and References
In Depth Information
neither of these labels corresponds to what the same commands are called in the Alignment Dialog
A couple other qualifications to what is again, not the sort of command you’re likely to call
upon daily: Click the left-pointing indent button arrow in the button group and nothing happens in the
cell at the outset—the data stay put. But click either left or right setting in the dialog box a n d ty pe a
number in the indent field and the data will i n de n t i n the de si r e d di r e cti on .
Sorry about that.
Center— Really an equivalent of the Center alignment button. Typing a number in Indent here
has no effect.
Fill —Takes any data you’ve written in the cell and repeats it in the cell, until the cell’s width is
taken up with the data. For example, if I type the word “the” in a cell and select Fill, I’ll see (Figure 4–
Figure 4–49. Filling the cell with data—repeatedly
And if I go on to widen the cell now, I’ll get Figure 4–50:
Figure 4–50. Same command, wider cell.
And yes, you can bring about the same effect with a number—though I can’t imagine why you’d
want to. That is, if I type 3 in a cell and invoke the Fill format I’ll see
across the width of the cell—but its actual value is still….3. Don’t ask questions, but remember—
this is a format , and as such, it doesn’t change the number’s value.
The Justify and Distributed options are similar, though not quite identical to one another. These
commands represent a kind inverse of the column Auto Fit; instead of widening a column to
accommodate i ts wi de st e n tr y , Justi fy an d Di str i bute d tr e at the cur r e n t col umn wi dth as a fi xe d mar g i n
and stack the text in the cell so that it all fits. So for example, if I type (Figure 4–51):
Figure 4–51 . Before justifying the text…
And select Justify, the text is realigned like this (Figure 4–52):