Microsoft Office Tutorials and References
In Depth Information
Session 3.1
To open the Format Cells dialog box:
1. Select the nonadjacent range B23:D25;F23:G26 .
2. Click Format on the menu bar, and then click Cells . The Format Cells dialog box opens, as
shown in Figure 3-5. In addition to the General format category, there are 11 number for-
mat categories from which to choose.
Format Cells dialog box
Figure 3-5
indicates category
of formatting
currently applied to
the active cell
options related to
the selected category
appear here
The Format Cells dialog box contains the following six tabs, each dedicated to a differ-
ent set of format properties. You can apply the options available in this dialog box to any
cell or range of cells that you select. The six tabs are:
Number: Provides options for formatting the appearance of numbers, including dates
and numbers treated as text (for example, telephone numbers)
Alignment: Provides options for controlling how data is aligned within a cell
Font: Provides options for selecting font types, sizes, and styles and other formatting
attributes, such as underlining and colors
Border: Provides options for adding borders around cells
Patterns: 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 modi-
fying their contents
Excel supports several categories of number formats, ranging from Accounting, which
you applied using the Currency Style button, to Scientific, which might be used for record-
ing engineering data. Figure 3-6 describes the number format categories.
Search JabSto ::

Custom Search