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

Change Formatting Based On Your Data! Conditional formatting provides a way for you to adjust the appearance of your data based on the data itself. Discover how to put this amazingly powerful feature to work for you, today. This comprehensive volume is available in two editions.

Check out Excel Conditional Formatting today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Adjusting Spell Check for Internet Addresses