Microsoft Office Tutorials and References
In Depth Information
Formatting Cell Content
Working with Alignment
and Spacing
Moving across the Home tab, the next group is
called Alignment—and that’s what its commands
control for your worksheet cells and their content.
You can choose how content is aligned
horizontally and vertically, whether or not the content is
indented, and even put content on a variety of
angles. To use these tools (shown and identified
in Figure 5-24), select the cells to which the
changes should apply, and make your choice
from the following buttons:
Orientation. Need to put your column
headings at an angle? Long headings can
take up less horizontal space if they’re at
an angle, as shown in Figure 5-25.
Alignment Options in
the Format Cells Dialog Box
The Format Cell Alignment command
opens the Format Cells dialog box, open to
the Alignment tab (shown in Figure 5-26).
Pick an exact angle for your content, using
the half-clock on the right, and use
alignment, control, and text direction options
on the left side of the dialog box. These are
mostly repetitions of what’s available on the
Home tab’s Alignment group.
Vertical Alignment. Use the Top, Middle,
or Bottom Align buttons to control how
the content of selected cells lines up
vertically. Bottom alignment is the default.
Middle
Align
Orientation
Top
Align
Bottom
Align
Wrap
Text
Align Text
Left
Center
Decrease
Indent
Merge &
Center
Figure 5-24
Two rows of tools populate the Alignment
group of the Home tab, controlling how
content lines up within your worksheet cells.
Align Text
Right
Increase
Indent
 
Search JabSto ::




Custom Search