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

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

Lower case initials are capitalized

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

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments