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
Windows
Shift + CapsLock
Mac
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 the cell in which you want to enter capital letters.
Turn CapsLock ON

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

Select the cell in which you want to enter text.

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

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