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

Using the Format Cells Dialog Box 159
✦ Justify wraps the text of a cell entry on different lines spread out with blank space so that they are vertically aligned between the top and bottom edges of the cell.
✦ Distributed wraps the text of the cell entry on different lines distributed evenly between the top and bottom edges of its cell.
Finally, as part of its alignment options, Excel lets you alter the orientation (the angle of the characters in an entry in its cell) and text direction (the way the characters are read). The direction is left-to-right for European languages and right-to-left for some languages, such as Hebrew and Arabic. (Chinese characters can also sometimes be read from right to left, as well.)
Wrapping text entries to new lines in their cells
You can use the Wrap Text button on the Ribbon’s Home tab or the Wrap Text check box in the Text Control section of the Alignment tab to have Excel create a multi-line entry from a long text entry that would otherwise spill over to blank cells to the right. In creating a multi-line entry in a cell, the program also automatically increases the height of its row if that is required to display all the text.
To get an idea of how text wrap works in cells, compare Figures 2-12 and 2-13. Figure 2-12 shows you a row of long text entries that spill over to suc- ceeding blank cells in columns to the right. Figure 2-13 shows you these same entries after they have been formatted with the Wrap Text option. The first long text entry is in cell A10 and the last in cell I10. They all use General alignment (same as Left for text) with the Wrap Text option.
Figure 2-12:
Worksheet with long text entries that spill over into blank cells on the right.
Book II Chapter 2
Formatting Worksheets