Microsoft Office Tutorials and References
In Depth Information
Aligning (and Realigning) Your Data
NOTE: The Format Cells dialog box consists of numerous tabs, each one housing a different
variety of formatting possibilities. This same dialog box appears again when you click the dialog
box launcher in the Alignment and Number button groups, but these groups highlight a different
tab in Format Cells.
Aligning (and Realigning) Your Data
The group to the immediate right of the Font button group is called the Alignment group.
It’s shown in Figure 5–20.
Figure 5–20. The Alignment button group
Its buttons don’t quite change the appearance of data; rather, they reposition data in its
respective cells. Recall that numeric data, or values, appear by default at the right edge
of cells, while text data is positioned, or aligned, at the left. The Alignment buttons allow
you to relocate the data to different positions, called orientations —both horizontal and
even vertical—in cells.
Changing Horizontal Alignment
The trio of buttons in the lower left of the group (see Figure 5–21) controls the horizontal
placement of data (you’ll see these in Word, too).
Figure 5–21. The horizontal alignment buttons
What they do is pretty self-evident. Here’s a quick exercise involving text alignment:
Click the far left button, Align Text Left, after you’ve selected a range of
cells, and their contents will be shifted to the cells’ left edges (of course,
if you’re working with text data, that’s where they’ll be anyway).
Click the next button along, called Center, and the data will zip to the
center of its cells.
Click the third of the three, Align Text Right, to shunt the data to the right
Search JabSto ::

Custom Search