Excel Hack

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

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

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

Small letters are capitalized

Press Enter. Small letters in the specified cell have been changed to capital letters.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments