Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Praveen Asundi
Date Posted: 2015/11/05
Muhammad Farooq
by Muhammad Farooq , Assistant HR , Mossassa-tu-Mariam

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

Atif Tanveer
by Atif Tanveer , Decision Support Specialist , Hamilton Health Science

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

More Questions Like This