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

Using the Format Cells Dialog Box 161
✦ Rotate Text Up rotates the text in the cell selection up 90 degrees from the baseline.
✦ Rotate Text Down rotates the text in the cell selection down 90 degrees from the baseline.
✦ Format Cell Alignment opens the Alignment tab on the Format Cells dialog box.
You can also alter the orientation of text in the cell selection on the Alignment tab of the Format Cells dialog box (Ctrl+1) using the following options in its Orientation area:
✦ Enter the value of the angle of rotation for the new orientation in the Degrees text box or click the spinner buttons to select this angle. Enter a positive value (such as 45) to have the characters angled above the normal 90-degree line of orientation and a negative value (such as –45) to have them angled above this line.
✦ Click the point on the sample Text box on the right side of the Orientation area that corresponds to the angle of rotation that you want for the characters in the selected cells.
✦ Click the sample Text box on the left side of the Orientation area to have the characters stacked one on top of the other (as shown in the orienta- tion of the word “Text” in this sample box).
After changing the orientation of entries in a selection, Excel automatically adjusts the height of the rows in the cell selection to accommodate the rota- tion up or down of the cell entries. Figure 2-14 shows the top part of a work- sheet after rotating the column headings for a new data table up 90 degrees. Note how Excel increased the height of row 10 to accommodate this change.
Fancy fonts and colors
You can assign any of the fonts that you’ve installed for your printer to cells in a worksheet. Along with selecting a new font (also known as a typeface), you can choose a new font size (in points), assign a font style (such as bold, italic, underline, or strikethrough), as well as change the color of the font.
Note that you can always tell the font and font size of the cell entry in the active cell by looking at the font name displayed in the Font combo box and the point size displayed in the Font Size combo box in the Font group on the Home tab of the Ribbon. You can also tell which, if any, text attributes are assigned to the entry by looking at the Bold, Italic, and Underline buttons in this group. Excel indicates which of these attributes have been assigned to the cell by highlighting the B, I, or U button in the standard beige highlight color.
Book II Chapter 2
Formatting Worksheets