Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Recording a Macro

Adding a Little Animation to Your Life

Converting a Range of URLs to Hyperlinks

Making the Formula Bar Persistent

Engineering Calculations

Digital Signatures for Macros

Fixing the Decimal Point

 

Spell-checking Uppercase Words

Summary: 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. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Excel includes a powerful spell-checker that, in reality, does a pretty good job. You can use this tool to locate potential spelling errors in your worksheets. If your worksheets contain lots of acronyms, you'll find that Excel flags most of them as misspelled words.

You can make sure that Excel ignores uppercase words in any spell-check by following these steps in versions of Excel prior to Excel 2007:

  1. Choose Options from the Tools menu. Excel displays the Options dialog box.
  2. Make sure the Spelling tab is selected. (Click here to see a related figure.)
  3. Make sure the Ignore Words in UPPERCASE check box is selected.
  4. Click on OK.

To accomplish the same task in Excel 2007, follow these steps:

  1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
  2. At the left side of the dialog box click Proofing. (Click here to see a related figure.)
  3. Make sure the Ignore Words in UPPERCASE check box is selected.
  4. Click on OK.

The only downside to this, of course, is if you use all uppercase for section titles or for other special words. In this case, Excel still ignores them, since they are uppercase. Make sure you change the setting of this check box based on the type of work you are doing in your worksheet.

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

More Power! For some people, the prospect of creating macros can be scary. Those who conquer their fears, however, find they become much more confident and productive once they learn how to make Excel do exactly what they want. ExcelTips: The Macros is an invaluable source for learning Excel macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of ExcelTips. Learn at your own pace, exactly the way you want.
 
Check out ExcelTips: The Macros today!