Excel: Spelling Not Checking Uppercase Text

 Last reviewed: September 12, 1996
Article ID: Q99927
The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0, 4.0a

SUMMARY

When you select the Ignore Words In UPPERCASE check box in the Spelling dialog box, this option remains selected until you clear it. Since the Spelling dialog box appears only when the Spelling tool suspects a misspelled word, this feature of the Spelling tool may be inconvenient if you switch to a document that contains text formatted in all uppercase letters and you want to be able to check the spelling of that document.

Workarounds

Clear the Ignore Words In UPPERCASE Check Box

To change the Ignore Words In UPPERCASE option while you are running Microsoft Excel:

  1. In any cell, enter a misspelled word that is formatted in lowercase letters.

  2. From the Options menu, choose Spelling.

    The Spelling command will select the misspelled word and the Spelling dialog box will appear.

  3. In the Spelling dialog box, clear the Ignore Words In UPPERCASE check box.

The Spelling command will now check all words in your document.

Modify the EXCEL4.INI File

You can also change the Ignore Words In UPPERCASE option by changing the [Spell Checker] section of the EXCEL4.INI file from 

   [Spell Checker]
   Ignore Caps=1
to: 

   [Spell Checker]
   Ignore Caps=0
Where Ignore Caps=0 sets the option to off (false), and Ignore Caps=1 sets the option to on (true).

REFERENCES

"User's Guide 1", version 4.0, pages 256-259.

KBCategory: kbother
KBSubcategory:

Additional reference words: 4.00 4.00a caps tshoot



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.