Excel has a powerful spell-checker that does an excellent job. However, if your worksheets contain lots of acronyms, you'll find that Excel flags a lot of them as misspelled words.
To force Excel to ignore uppercase words in any spell-check you need to do the following:
The only problem with this solution happens 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.
To force Excel to ignore uppercase words in any spell-check you need to do the following:
- Click the File tab of the ribbon and then select Options.
- At the left side of the dialog box click Proofing.
- Make sure the Ignore Words in UPPERCASE check box is selected.
- Click on OK.
The only problem with this solution happens 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.
RSS Feed