Search

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.

correct-accidental-use-of-capslock-key.jpg

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.

 

Related Tutorials
AutoCorrect in Excel
How to open AutoCorrect Options dialog in Excel
How to add items to Excel AutoCorrect list
Math AutoCorrect in Excel
Show AutoCorrect Options buttons in Excel
Correct two initial capitals Excel AutoCorrect
Capitalize first letter of sentences in Excel AutoCorrect
Capitalize names of days in Excel AutoCorrect
Correct accidental use of cAPS LOCK key in Excel AutoCorrect
AutoComplete in Excel
Pick from drop-down menu in Excel and Alt+Down arrow in Excel