Excel 2010 Bible

Chapter 32: Making Your Worksheets Error-Free

671

10. 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.

FIGURE 32.16

Use the Find and Replace dialog box to change formatting.

Caution
The Find and Replace dialog box cannot find background color formatting in tables that was applied using
table styles, or formatting that is applied based on conditional formatting. n

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 spell-

ing in just a particular range, select the range before you activate the spell checker.

If the spell checker finds any words it does not recognize as correct, it displays the Spelling dialog

box, shown in Figure 32.17.

Note
The spell checker checks cell contents, text in graphic objects and charts, and page headers and footers. Even
the contents of hidden rows and columns are checked. n