Excel Hack

How to Caps lock in Excel

When entering data in Excel, you may find yourself typing in capital letters more often than small letters. In such cases, it may be more efficient to apply CapsLock so that capital letters can be entered by default, rather than pressing Shift for a long time to enter capital letters. Some people also unknowingly press CapsLock and are only able to type capital letters. This section explains how to apply and remove CapsLock.

Shortcut to lock/unlock capital letters

Shift + CapsLock

caps lock

Lock capital letters

For information on how to lock in capital letters when entering text in Excel, see the following.

Total Time: 1 minute

Select a cell

Select a cell

Select the cell in which you want to enter capital letters.

Turn CapsLock ON

Turn CapsLock ON

Press Shift + CapsLock. When letters are entered, they are displayed in all capital letters.

Unlock capital letters

Select a cell

Select the cell in which you want to enter text.

Typing with CapsLock engaged

Try to type a letter, but because CapsLock is engaged, only capital letters can be entered.

Unlock CapsLock to type

Press Shift + CapsLock.

CapsLock will be unlocked and all letters will be displayed in small letters when you try to type.

Articles related to Caps & Lock


Please send us your comments on this article.

Inline Feedbacks
View all comments