Microsoft Office Tutorials and References
In Depth Information
Formatting Cell Content
Horizontal Alignment. Choose from
Align Text Left, Center, and Align Text
Right buttons, to align cell content to
the sides or center of the selected cells.
Indent. You can indent cell content,
moving it to the right within the cell with
each click of the Increase Indent button.
The Decrease Indent button moves the
text back to the left.
Merge & Center. This button works to
toggle merging of selected cells on and
off, and also displays a menu, as shown
in Figure 5-27. The most common use of
this button is to merge a series of cells to
make a single title cell above a series of
columns. The list offers commands to
Merge Across (to merge a horizontal
series of cells), Merge Cells (to merge a
block of cells, including vertical ranges),
and Unmerge Cells, which removes the
merge and returns the cells to their
Angle your cells’ content using the five choices
on the Orientation palette.
The Alignment tab of the Format Cells
dialog box offers more tools to do the same
things you can do from the Home tab.
Merge & Center a title, using the button
or this handy list of options.
Wrap Text. Click this button to tell Excel
to allow wrapping within the selected
cells. This can come in handy for cells that
will contain long strings of text—sentences,
product descriptions, survey comments,
anything longer than a couple of words,
where you don’t want the column to have
to be very wide to accommodate the full
display of the text.