Microsoft Office Tutorials and References
In Depth Information
Align Text Within a Cell
5
chapter
Formatting Excel Ranges
Align Text Vertically
1 Select the range you want to
format.
2 Click the Home tab.
3 In the Alignment group, click
the vertical alignment option
you want to use:
Click Top Align ( ) to align
data with the top of each
cell.
Click Middle Align ( ) to
align data with the middle of
each cell.
Click Bottom Align ( ) to
align data with the bottom of
each cell.
Excel aligns the data
vertically within each
selected cell.
B In this example, the text is
aligned with the middle of
the cell.
How do I format text so that it aligns with
both the left and right sides of the cell?
Select the range, click the Home tab, and then
click the dialog box launcher ( ) in the
Alignment group. In the Alignment tab of the
Format Cells dialog box, click the Horizontal
and then click Justify . Click OK to justify
the cells.
How do I indent cell text?
Select the range you want to indent, click
the Home tab, and then click the Alignment
group’s dialog box launcher ( ). In the
Alignment tab, click the Horizontal and
then click Left (Indent) . Use the Indent
text box to type the indent, in characters,
and then click OK.
Search JabSto ::




Custom Search