Microsoft Office Tutorials and References
In Depth Information
More About Using Styles
Keep in mind the following additional points concerning styles:
1. A style affects the format of a cell or range of cells only if the corresponding check
box is selected in the ‘Style Includes area’ in the Style dialog box (Figure 6–27 on
page EX 442). For example, if the Font check box is not selected in the Style dia-
log box, then the cell assigned the style maintains the font format it had before the
style was assigned.
2. If you assign two different styles to a range of cells, Excel adds the second style to
the ﬁ rst, rather than replacing it.
3. You can merge styles from another workbook into the active workbook by using
the Merge Styles button in the Cell Styles gallery. You must, however, open the
workbook that contains the desired styles before you use the Merge Styles button.
4. The six check boxes in the Style dialog box are identical to the six tabs in the
Format Cells dialog box (Figure 6–26 on page EX 442).
Each format symbol
within the format code
has special meaning.
Table 6–2 on page EX 438
summarizes the more
frequently used format
symbols and their
To Spell Check, Save, and Print the Template
The Normal style is the
format style that Excel
initially assigns to all
cells in a workbook. If
you change the Normal
style, Excel applies the
new format speciﬁ cations
to all cells that are not
assigned another style.
With the formatting complete, the next step is to spell check the template, save it,
and then print it.
1 Select cell A1. Click the Spelling button on the Review tab. Correct any misspelled words.
2 Click the Save button on the Quick Access Toolbar to save the workbook.
3 Print the workbook.
4 Click the Close Window button on the right side of the worksheet window to close the
workbook and leave Excel open.
Opening a Workbook
You can instruct Windows
to open a workbook
(or template) automati-
cally when you turn on
your computer by add-
ing the workbook (or
template) to the Startup
folder. Use Windows
Explorer to copy the ﬁ le
to the Startup folder. The
Startup folder is in the All
Before using the template to create the NextDVR Proﬁ t Potential workbook, you should
be aware of how templates are used and their importance. If you click the New command
on the Ofﬁ ce Button menu, the New Workbook dialog box is displayed (Figure 6–30).
The New Workbook dialog box includes a My templates link in the Templates list, which
you can click to view a list of Excel templates that you have saved on your computer in the
New dialog box.
Recall that Excel automatically chose Templates as the Save in folder when the
template in this chapter initially was saved (Figure 6–16 on page EX 443). Saving tem-
plates in the Templates folder, rather than in another folder, is the standard procedure
in the business world. If the NextDVR Proﬁ t Potential template created in this chapter
had been saved in the Templates folder, then the template would appear in the New
Workbook dialog box after clicking My templates in the Templates list. The template then
could have been selected to start a new workbook.