Adjusting Spell Check for Internet Addresses

Summary: When you check the spelling of worksheet data, you may want to spell checker to either ignore or check Internet addresses such as URLs and e-mail addresses. This tip shows how you can make a configuration change that will enforce your desires. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

If you use the spelling checker to examine the text in a worksheet, you might want it to ignore Internet-related data, such as URLs and e-mail addresses. You can instruct the spelling checker to ignore anything that looks like an Internet address by following these steps if you are using a version of Excel prior to Excel 2007:

Choose Options from the Tools menu. Excel displays the Options dialog box.
Make sure the Spelling tab is selected. (Click here to see a related figure.)
Make sure the Ignore Internet and File Addresses check box is selected.
Click on OK.

The steps are different if you are using Excel 2007. Follow these steps:

Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
At the left side of the dialog box click Proofing. (Click here to see a related figure.)
Make sure the Ignore Internet and File Addresses check box is selected.
Click on OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3372) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

PivotTables Got You Perplexed? PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of creating PivotTables, editing them, formatting them, customizing them, and much more.

Check out PivotTables for the Faint of Heart today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Adjusting Spell Check for Internet Addresses