Capital to small letter in Excel shortcut
When you want to change capital letters to small letters, many people delete the capital letters and then retype the small letters. When the volume of data is large, manual work takes an enormous amount of time. Learning a shortcut to change to small letters can save a lot of time. It is a good idea to learn it to increase your work productivity.
Shortcut to make small letters
Access Key: Alt + M + T
Use shortcuts to make small letters
See below for a shortcut from capital letters to small letters.
Total Time: 1 minute
Select a cell
Select one cell that you want to change from capital letters to small letters. Check the cell range containing capital letters (ex B2:B7).
Select LOWER function
Press Alt + M + T and then press ↓ (Down Arrow key) several times to select LOWER.
Specify a range of cells containing capital letters
Press Enter. The Function Arguments dialog box appears. Enter a cell range (ex B2:B7) containing capital letters in Text.
Capital letters are lowercased
Press Enter. The capital letters in the specified cell have been changed to small letters.