Written by Allen Wyatt (last updated June 10, 2021)
This tip applies to Excel 97, 2000, 2002, and 2003
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:
Figure 1. The Spelling tab of the Options dialog box.
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 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Spell-checking Uppercase Words.
Best-Selling VBA Tutorial for Beginners Take your Excel knowledge to the next level. With a little background in VBA programming, you can go well beyond basic spreadsheets and functions. Use macros to reduce errors, save time, and integrate with other Microsoft applications. Fully updated for the latest version of Office 365. Check out Microsoft 365 Excel VBA Programming For Dummies today!
When Excel does a spell-check of the information in a worksheet, you may want it to ignore words that contain numbers. ...
Discover MoreThe spell checker can come in handy when entering data in a worksheet. Because the type of data you enter can vary so ...
Discover MoreWhen you protect a worksheet, you can't use some tools, including the spell-checker. If you want to use it, you must ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments