How can you change small letters to capital letters in excel with short keys?

Simply highlight the text you would like to change. Then press the Shift + F3 shortcut key. It will change between sentence case, all caps, and all lowercase letters. Keep pressing the shortcut key until the font is in the desired case.

Use =Upper() function to convert small letters to capital then past the result as value on small letters.