Excel Hack

Capital to small letter in Excel shortcut

When you want to change capital letters to small letters, many people delete the capital letters and then retype the small letters. When the volume of data is large, manual work takes an enormous amount of time. Learning a shortcut to change to small letters can save a lot of time. It is a good idea to learn it to increase your work productivity.

Shortcut to make small letters

Windows
Access Key: Alt + M + T

Mac
None

Use shortcuts to make small letters

See below for a shortcut from capital letters to small letters.

Total Time: 1 minute

Select a cell

Select a cell

Select one cell that you want to change from capital letters to small letters. Check the cell range containing capital letters (ex B2:B7).

Select LOWER function

Select the LOWER function

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

Specify a range of cells containing capital letters

Select a range of cells containing uppercase letters

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

Capital letters are lowercased

Change capital letters to small letters

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