Spell check a Region

October 05, 2021 - by Bill Jelen

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

The Proofing group offers Spelling, Research, and Thesaurus
Figure 103. 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. Another Gotcha: By default, Excel will not spell-check any capitalized words. Go to File, Options, Proofing to change this setting.

The default spell check settings say to ignore words in UPPERCASE, words that contain numbers, Internet web addresses. It will also flag flag repeated words.
Figure 104. By default, Excel will not spell check words in ALL CAPS.

This article is an excerpt from Power Excel With MrExcel

Title photo by Pisit Heng on Unsplash

Bill Jelen is the author / co-author of:
Excel Dynamic Arrays Straight to the Point 2nd Edition

Fifteen months after Dynamic Arrays debuted for Office Insiders, the functions are being released to General Availability. This second edition of the book has been updated with new examples: see how Dynamic Arrays make XLOOKUP better. The chapter on the logic behind arrays has been expanded.