What is the shortcut to change small letters to capital letters in Excel
When you want to capitalize small letters, it is time-consuming to delete the small letters and then retype the capital letters. This is fine if the data is small, but if there is a lot of data, it can take an enormous amount of time to perform that task. If you learn a shortcut for capitalizing small letters, you can save a great deal of time in that task. Please learn it to improve your work productivity.
Shortcut to capitalize small letters
Windows
Access Key: Alt + M + T
Mac
None
Use the shortcut to capitalize small letters
For information on how to use shortcuts to capitalize small letters, see below.
Total Time: 1 minute
Select a cell
Select one cell in which you want to change from small letters to capital letters. Check the range of cells with only small letters (ex B2:B7).
Select UPPER function
Press Alt + M + T and then press ↓ (Down Arrow key) several times to select UPPER.
Specify a range of cells containing small letters
Press Enter. The Function Arguments dialog box appears. Enter a lowercase cell range (ex B2:B7) in Text.
Small letters are capitalized
Press Enter. Small letters in the specified cell have been changed to capital letters.