Microsoft Office Tutorials and References
In Depth Information
Altering the Alignment
can change how many characters an entry indents with the Increase Indent
button (or outdents with the Decrease Indent button). Open the Format Cells
dialog box (Ctrl+1). Select the Alignment tab, and then alter the value in the
Indent text box (by typing a new value in this text box or by dialing up a new
value with its spinner buttons).
From top to bottom
Left, right, and center alignment all refer to the horizontal positioning of a text
entry in relation to the left and right cell borders (that is, horizontally). You
can also align entries in relation to the top and bottom borders of their cells
(that is, vertically). Normally, all entries align vertically with the bottom of
the cells (as though they were resting on the very bottom of the cell). You
can also vertically center an entry in its cell or align it with the top of its cell.
To change the vertical alignment of a cell range that you’ve selected, click
the appropriate button (Top Align, Middle Align, or Bottom Align) in the
Alignment group on the Home tab.
Figure 3-13 shows the title for the 2013 Mother Goose Enterprises sales
worksheet after centering it vertically in its cell by clicking the Middle Align
button on the Home tab. (This text entry was previously centered across the
cell range A1:E1; the height of row 1 is increased from the normal 15 points to
of row 1.