Microsoft Office Tutorials and References
In Depth Information
Exploring Options in the Format Cells Dialog Box
Figure 2-17
Borders added to cells
Border button
column titles ha ve a
single bottom border
Total row has a single
top b order and a
double bottom border
Exploring Options in the Format Cells Dialog Box
The buttons on the Home tab provide quick access to the most commonly used
formatting choices. For more options, you can use the Format Cells dialog box. For example,
the numbers in cells E8 and E11 are displayed in parentheses to indicate that they are
negative. Although parentheses are common in accounting to indicate negative currency
values, Tom wants you to reformat the units sold numbers to display negative numbers
with a minus symbol. You can do this in the Format Cells dialog box.
To open the Format Cells dialog box:
You can also open the
Format Cells dialog box
by right-clicking a cell or
selected range, and then
clicking Format Cells on
the shortcut menu.
1. Select the range E7:E15 .
2. In the Number group on the Home tab, click the Dialog Box Launcher . The
Format Cells dialog box opens with the Number tab active.
The Format Cells dialog box has six tabs, each focusing on a different set of
formatting options, as described below. You can apply the formats in this dialog box to selected
worksheet cells.
Number provides options for formatting the appearance of numbers, including dates
and numbers treated as text (for example, telephone or Social Security numbers).
Alignment provides options for how data is aligned within a cell.
Font provides options for selecting font types, sizes, styles, and other formatting
attributes such as underlining and font colors.
Border provides options for adding and removing cell borders as well as selecting a
line style and color.
Fill provides options for creating and applying background colors and patterns to cells.
Protection provides options for locking or hiding cells to prevent other users from
modifying their contents.
Search JabSto ::

Custom Search