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

Access Key: Alt + M + T


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 the 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 made uppercase

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