Excel: Spell check a Region

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

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

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