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

160 Using the Format Cells Dialog Box
Figure 2-13:
Worksheet after wrapping long text entries in their cells, increasing the height of their rows.
When you create multi-line text entries with the Wrap Text option, you can decide where each line breaks by inserting a new paragraph. To do this, you put Excel in Edit mode by clicking the insertion point in the Formula bar at the place where a new line should start and pressing Alt+Enter. When you press the Enter key to return to Ready mode, Excel inserts an invisible paragraph marker at the insertion point that starts a new line both on the Formula bar and within the cell with the wrapped text.
If you ever want to remove the paragraph marker and rejoin text split on different lines, click the insertion point at the beginning of the line that you want to join on the Formula bar and press the Backspace key.
Reorienting your entries
Excel makes it easy to change the orientation (that is, the angle of the base- line on which the characters rest) of the characters in a cell entry by rotat- ing up or down the baseline of the characters.
The Orientation command button in the Alignment group on the Ribbon’s Home tab contains the following options on its drop-down menu:
✦ Angle Counterclockwise rotates the text in the cell selection up 45 degrees from the baseline.
✦ Angle Clockwise rotates the text in the cell selection down 45 degrees from the baseline.
✦ Vertical Text aligns the text in the cell selection in a column where one letter appears over the other.