Part II: Working with Formulas and Functions
- Click the top Format button. The Find Format dialog box appears. This dialog box
resembles the standard Format Cells dialog box.
- Select the Font tab.
- Select Bold in the Font Style list and then click OK.
- Click the bottom Format button. The Replace Format dialog box appears.
- Select the Font tab.
- Select Bold Italic from the Font Style list and then click OK.
- In the Find and Replace dialog box, click Replace All. Excel locates all cells that
have bold formatting and changes the formatting to bold italic.
You can also find formatting based on a particular cell. In the Find Format dialog box, click
the Choose Format from Cell button and then click the cell that contains the formatting
you’re looking for.
The Find and Replace dialog box can’t find background color formatting in tables that was applied using table styles
or formatting that is applied based on conditional formatting.
Spell-checking your worksheets
If you use a word-processing program, you probably take advantage of its spell-checker
feature. Spelling mistakes can be just as embarrassing when they appear in a spreadsheet.
Fortunately, Microsoft includes a spell-checker with Excel.
To access the spell-checker, choose Review ➪ Proofing ➪ Spelling, or press F7. To check the
spelling in just a particular range, select the range before you activate the spell-checker.
The spell-checker checks cell contents, text in graphics objects and charts, and page headers and footers. Even the
contents of hidden rows and columns are checked.
The Spelling dialog box works similarly to other spell-checkers with which you may be
familiar. If Excel encounters a word that isn’t in the current dictionary or that is mis-
spelled, it offers a list of suggestions. You can respond by clicking one of these buttons:
Ignore Once Ignore the word and continue the spell-check.
Ignore All Ignore the word and all subsequent occurrences of it.
Add to Dictionary Add the word to the dictionary.
Change Change the word to the selected word in the Suggestions list.
Change All Change the word to the selected word in the Suggestions list and change all
subsequent occurrences of it without asking.
