Microsoft Office Tutorials and References
In Depth Information
Getting Oriented
Figure 4–34. Centered text
Nothing prevents you from centering numbers in their cells, and this alignment decision seems to
be a popular one. Users seem to like the symmetry it affords. Still, I wouldn’t recommend it, and for an
obvious reason (Figure 4– 35):
Figure 4–35. It’s your call: centered numbers…if you like this sort of thing
You see the problem. Enter numbers of varying widths in the same column, center them, and you’ll
thereby misalign the ones, tens, etc. But remember that alignments, no matter how ornate, won’t
change the quality of the data. Those numbers above are still numbers, and can be subject to exactly
the same mathematical treatment as if they are right-aligned.
And while we’re at it, the right-align button rams data to the right border of their cells—which is
the default alignment for numbers, after all.
The upper tier of alignment buttons controls a far more exotic set of possibilities— vertical
alignment in cells (Figure 4–36):
Figure 4–36. Where to control vertical cell alignment
If you need your data to look like this (Figure 4–37):
Search JabSto ::

Custom Search