Excel Hack

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

Windows
Access Key: Alt + M + T

Mac
None

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 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

Select PROPER function

Press Alt + M + T and then press (Down Arrow key) several times to select PROPER.

Enter a range of lowercase cells

Select a range of cells to reference

Press Enter. The Function Arguments dialog box appears. Enter a lowercase cell range (ex B2:B7) in Text.

Lower case initials are capitalized

Capitalize leading lowercase letters

Press Enter. Lowercase initials in the specified cell range are now uppercase.