Microsoft Office Tutorials and References
In Depth Information
Exploring Options in the Format Cells Dialog Box
Although you’ve applied many of these formats from the Home tab, the Format Cells
dialog box presents them in a different way and provides more choices. You’ll use the
Number tab to change the number format for the selected cells. Remember, modifying
the number format does not affect the value stored in the workbook.
To set the format for negative values:
1. In the Category box on the left side of the Format Cells dialog box, click Number .
2. Verify that (zero) appears in the Decimal places box. 0
3. Verify that the Use 1000 Separator (,) check box contains a check mark.
4. In the Negative numbers box, verify that −1,234 (the first option) is selected. See
Number tab in the Format Cells dialog box
preview of how the
number in the selected
cells will appear
number format categories
opt ions for displaying
5. Click the OK button. The Format Cells dialog box closes and the negative
numbers in the range E7:E15 appear with a minus symbol, a comma as the thousands
separator, and no decimal places.
Tom wants the bottom border color used for the column titles changed from black to
green. You’ll use the Border tab in the Format Cells dialog box to set the border line color
and make this change. On the Border tab, you can select a line style ranging from thick
to thin, choose double to dotted lines, and place these lines anywhere around the cells
in the selected range.
To set the border color for the column labels:
1. Select the nonadjacent range B6:F6;B17:F17 .
2. In the Font group on the Home tab, click the Borders button arrow , and
then click More Borders . The Format Cells dialog box opens with the Border