Microsoft Office Tutorials and References
In Depth Information
Aligning data in cells
The Alignment tab in the Format Cells dialog box includes the following options:
Horizontal These options control the right or left alignment within the cell. The
General option, the default for Horizontal alignment, right-aligns numeric values and
left-aligns text values.
These options control the top-to-bottom position of cell contents within
Text Control These three check boxes wrap text in cells, reduce the size of cell
contents until they it in the current cell width, and merge selected cells into one.
Text Direction The options in this drop-down list format individual cells for
rightto-left languages. The default option is Context, which responds to the regional
settings on your computer. (This feature is applicable only if support is available for
Orientation These controls let you precisely specify the angle of text within a cell,
from vertical to horizontal and anywhere in between.
Aligning text horizontally
The Align Left, Center, and Align Right buttons on the ribbon correspond to three of the
options in the Horizontal drop-down list on the Alignment tab in the Format Cells
dialog box: Left (Indent), Center, and Right (Indent). These options align the contents of the
selected cells, overriding the default cell alignment. Figure 9-46 shows the Horizontal
alignment options in action, all of which we’ll discuss in detail in the following sections.
Figure 9-46 Use the Horizontal alignment options to control the placement of text from left