Replacing all lowercase letters with uppercase in Excel: how to do

While working in Excel, there is often a need to print all the text in capital letters. This may be required, for example, when filling out various applications and other official papers for submission to government agencies. Surely, many may think – what is so complicated and incomprehensible about this? After all, every PC user knows that all you need to do is press Caps Lock on the keyboard, after which all information will be typed in capital letters.

Yes, this is absolutely true, and one press of the Caps Lock key in this case is enough. But what about in a situation where the document already contains text printed in regular letters? At the beginning of the work, the user does not always think about the form in which the final text should be presented, and often begins its formatting after entering the information. Do not retype the text again?

In such a situation, you should not panic, and, moreover, retype everything again, as there are tools to help you quickly solve this problem. Let’s take a look at all the possible ways to change all letters to uppercase in Excel.

Leave a Reply