How to Caps lock in Excel

• Release Feb 1, 2022Update Aug 24, 2022
• Written in Excel for Microsoft 365 version 2202

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.