• Excel Book Excerpt

Excel Spell check a Region

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Spell check a Region

Problem: I want to spell check the notes at the bottom of a report, but I don’t want to spell check the customer names in the report. How can I accomplish this?

Strategy: You can select the region to be spell checked and then choose Review, Spelling. (Or press F7, the Spelling shortcut key).

LE10000082.jpg 

Figure 112 Select cells before invoking the Spelling command..

Results: Excel will spell check just the selected cells.

Gotcha: If you indicate to spell check a single cell, Excel will expand your selection to the entire worksheet. To get around this problem, you can select the desired cell and any one adjacent cell. When you have two or more cells selected, Excel will check only the selection.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel:

privacy policy