First letter capital in Excel shortcut keys
In many cases, you will want to capitalize the first letter of a letter entered in multiple cells at once. However, many people may not know how to use a shortcut to capitalize the initial letters of multiple cells. If you learn how to use this shortcut, you can finish this task in an instant, even if you have a lot of data. The shortcut is explained in detail here.
Shortcut to capitalize the first letter
Access Key: Alt + M + T
Use the shortcut key to capitalize the first letter
For a shortcut to capitalize lowercase initials in a selected range, see below.
Total Time: 1 minute
Select a cell
Select one cell to capitalize the first letter. Check the range of cells with only lowercase letters (ex B2:B7).
Select PROPER function
Press Alt + M + T and then press ↓ (Down Arrow key) several times to select PROPER.
Enter a range of lowercase cells
Press Enter. The Function Arguments dialog box appears. Enter a lowercase cell range (ex B2:B7) in Text.
Lower case initials are capitalized
Press Enter. Lowercase initials in the specified cell range are now uppercase.