Page 176 - Excel 2013 All-in-One For Dummies

158 Using the Format Cells Dialog Box
✦ Right (Indent) right-aligns the entry in its cell and indents the charac- ters from the right edge of the cell by the number of characters entered in the Indent combo box (which is 0 by default).
✦ Fill repeats the entry until its characters fill the entire cell display. When you use this option, Excel automatically increases or decreases the repe- titions of the characters in the cell as you adjust the width of its column.
✦ Justify spreads out a text entry with spaces so that the text is aligned with the left and right edges of its cell. If necessary to justify the text, Excel automatically wraps the text onto more than one line in the cell and increases the height of its row. If you use the Justify option on num- bers, Excel left-aligns the values in their cells just as if you had selected the Left align option.
✦ Center Across Selection centers a text entry over selected blank cells in columns to the right of the cell entry.
✦ Distributed (Indent) indents the text in from the left and right cell mar- gins by the amount you enter in the Indent text box or select with its spinner buttons (which appear when you select this option from the Horizontal drop-down list) and then distributes the text evenly in the space in between.
For text entries in the worksheet, you can also add the Wrap Text check box option to any of the horizontal alignment choices. (Note that you can also access this option by clicking the Wrap Text button in the Alignment group of the Home tab on the Ribbon.) When you select the Wrap Text option, Excel automatically wraps the text entry to multiple lines within its cells while maintaining the type of alignment that you’ve selected (something that automatically happens when you select the Justify alignment option).
Instead of wrapping text that naturally increases the row height to accom- modate the additional lines, you can use the Shrink to Fit check box option on the Alignment tab of the Format Cells dialog box to have Excel reduce the size of the text in the cell sufficiently so that all its characters fit within their current column widths.
In addition, Excel offers the following vertical text alignment options from the Vertical drop-down list:
✦ Top (the default) aligns any type of cell entry with the top edge of its cell.
✦ Center centers any type of cell entry between the top and bottom edges of its cell.
✦ Bottom aligns any type of cell entry with the bottom edge of its cell.