Tips, Tricks, and Answers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Adjusting Spell Check for Internet Addresses 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Allowing for Words that Contain Numbers When Excel does a spell-check of the information in a worksheet, you may want it to ignore words that contain numbers. All it takes is a simple change to the configuration options for the spell-checker. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Backing Up Custom Dictionaries The custom dictionary used in Excel contains the information you decide relative to spelling. After a while, you might start to realize how much work it took to get that dictionary just as you like it. Here’s how to back up all that work. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Setting Spell-Checking Options The spell checker can come in handy when entering data in a worksheet. Because the type of data you enter can vary so much from worksheet to worksheet, it is good that you can configure the spell checker to either ignore or pay attention to certain items. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Spell Checking Your Worksheet Using spell checker on Excel worksheets. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Spell-Checking in a Protected Worksheet When you protect a worksheet, you can’t use some tools, including the spell-checker. If you want to use it, you must unprotect the worksheet, run the check, and then protect it again. All of this can be done quite quickly by using the macros discussed in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Spell-checking Uppercase Words Excel’s spell-checker normally checks uppercase words for spelling. If your worksheet contains a lot of acronyms, you might not want those uppercase words checked. Here’s how to adjust the spell-checker so it ignores uppercase words. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)