Correct accidental use of cAPS LOCK key in Excel AutoCorrect
Correct accidental use of cAPS LOCK key in Excel AutoCorrect helpful when you type the first letter of a word as small letter and then remaining letters of the word as capital letters. When this happens, Excel automatically turns off Caps Lock and then changes the word as first letter capital and remaining as small letters. Normally this happens when the Caps Lock key is on without your knowledge and then you press Shift key to capitalize the first word of a sentence.
Correct accidental use of cAPS LOCK key is enabled in Excel, by default.
"Correct accidental use of cAPS LOCK key" settings can be enabled or disabled in Excel AutoCorrect dialog box. If you are not sure how to open Excel AutoCorrect dialog box, click the next link to learn how to open Excel AutoCorrect dialog box.
If you want to disable Excel automatically correct the accidental use of Caps Lock key, uncheck the "Correct accidental use of cAPS LOCK key" checkbox.
If you want to enable Excel automatically correct the accidental use of Caps Lock key, check the "Correct accidental use of cAPS LOCK key" checkbox.