XL97: AutoCorrect May Not Capitalize First Word in Sentence

ID: Q154958

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

If you enter a sentence in a cell, AutoCorrect may not capitalize the first word in the sentence. This behavior may occur even if you have "Capitalize first letter of sentence" selected (checked) in the AutoCorrect dialog box.

MORE INFORMATION

Because you do not enter most text in a spreadsheet in complete sentences, the AutoCorrect feature in Microsoft Excel only corrects the capitalization in sentences preceded by a period and followed by a space. Note, if you type multiple sentences in a cell and end the first and subsequent sentences with a period and a space, the AutoCorrect feature capitalizes the first word of the second and subsequent sentences.

The AutoCorrect feature in Microsoft Excel corrects text automatically as you type. It offers the ability to correct the following situations:

words that begin with two capital letters

correct sentences where the first word is not capitalized

correct days of the week that are not capitalized

correct accidental use of the CAPS key

correct words that you commonly misspell

You can turn each of these options on or off in the AutoCorrect dialog box. To display the AutoCorrect dialog box, click AutoCorrect on the Tools menu.

REFERENCES

For more information about AutoCorrect, click the Index tab in Microsoft Excel 97 Help, type the following text

AutoCorrect

and then double-click the selected text to go to the "Spell Checking" topic.

Additional query words: auto correct

Keywords : kbualink97 kbdta
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb