Chapter 2 Working with Data 43Comma Style Add comma separators to values
(i.e., 43215 = 43,215).
Increase Decimal Increase the number of decimal points
(i.e., 4.3 = 4.300).
Decrease Decimal Decrease the number of decimal points
(i.e., 4.321 = 4.3).
Fill Color Change the cell’s background color.
Font Color Change the color of the selected text.
Merge and Center Merge the selected cells and center the text across
the merged cells.
You can access all of the possible formatting options for a particular cell
by opening the Format Cells dialog box. To see this feature of Excel, you’ll
use it to continue formatting the column titles, changing the font color
to red.To open the Format Cells dialog box:1 Select the cell range, A1:C1.
2 Right-click the selection and click Format Cells from the shortcut
menu.
The Format Cells dialog box contains six dialog sheets labeled
Number, Alignment, Font, Border, Patterns, and Protection. Each
deals with a specifi c aspect of the cell’s appearance or behavior in
the workbook. You’ll fi rst change the font color to red. This option is
located in the Font dialog sheet.
3 Click the Font tab.
4 Click the Color drop-down list box and click the Red checkbox
(located as the second entry in the list of standard colors.) See
Figure 2-6.