Microsoft Office Tutorials and References
In Depth Information
Additional Spell Checker Considerations
Consider these additional guidelines when using the spell checker:
• To check the spelling of the text in a single cell, double-click the cell to make the formula
bar active and then click the Spelling button on the Review tab on the Ribbon.
• If you select a single cell so that the formula bar is not active and then start the
spell checker, Excel checks the remainder of the worksheet, including notes and
• If you select a cell other than cell A1 before you start the spell checker, Excel will
display a dialog box when the spell checker reaches the end of the worksheet, asking
if you want to continue checking at the beginning.
• If you select a range of cells before starting the spell checker, Excel checks the
spelling of the words only in the selected range.
• To check the spelling of all the sheets in a workbook, click Select All Sheets on the
sheet tab shortcut menu and then start the spell checker. To instruct Excel to display
the sheet tab shortcut menu, right-click any sheet tab.
• To add words to the dictionary such as your last name, click the Add to Dictionary
button in the Spelling dialog box (Figure 2–61 on page EX 127) when Excel identiﬁ es
the word as not in the dictionary.
• Click the AutoCorrect button (Figure 2–61) to add the misspelled word and the correct
version of the word to the AutoCorrect list. For example, suppose you misspell the
word, do, as the word, dox. When the spell checker displays the Spelling dialog
box with the correct word, do, in the Change to box, click the AutoCorrect button.
Then, anytime in the future that you type the word, dox, Excel automatically will
change it to the word, do.
While Excel’s spell
checker is a valuable
tool, it is not infallible.
You should proofread
your workbook carefully
by pointing to each
word and saying it
aloud as you point to it.
Be mindful of misused
words such as its and it’s,
through and though,
and to and too. Nothing
undermines a good
impression more than
a professional looking
report with misspelled
Always take the time
to check the formulas
of a worksheet before
submitting it to your
supervisor. You can check
formulas by clicking the
Error Checking button on
the Formulas tab on the
Ribbon. You also should
test the formulas by
employing data that tests
the limits of formulas.
specialists spend as much
time testing a workbook
as they do creating it,
before placing it into
Excel allows for a great deal of customization in how a worksheet appears when printed.
For example, the margins on the page can be adjusted. A header or footer can be added to
each printed page as well. Excel also has the capability to work on the worksheet in Page
Layout View. Page Layout View allows you to create or modify a worksheet while viewing
how it will look in printed format. The default view that you have worked in up until this
point in the book is called Normal View .
Specify how the printed worksheet should appear.
Before printing a worksheet, you should consider how the worksheet will appear when
printed. In order to ﬁ t as much information on the printed page as possible, the margins of
the worksheet should be set to a reasonably small width and height. The current Portfolio
Summary worksheet will print on one page. If, however, the club added more data to the
worksheet, then it may extend to multiple pages. It is, therefore, a good idea to add a page
header to the worksheet that prints in the top margin of each page.
In Chapter 1, the worksheet was printed in portrait orientation , which means the printout
is printed across the width of the page. Landscape orientation means the printout is printed
across the length of the page. Landscape orientation is a good choice for the Silver Dollars
Stock Club Portfolio Summary because the printed worksheet’s width is greater than its
The Microsoft Certiﬁ ed
(MCAS) program provides
an opportunity for you
to obtain a valuable
industry credential –
proof that you have the
Excel 2007 skills required
by employers. For
more information, see
Appendix G or visit the
Excel 2007 Certiﬁ cation
Web page (scsite.com/