Change the text capitalization: in Word, Excel, OpenOffice

You often need to change the case of your text, e.g., switch from a text written in uppercase to lowercase and vice-versa, all without having to retype the entire text. In this article, we'll provide some simple but effective solutions, so read on.

How to change the capitalization on Microsoft Word?

• Select the text you want to change to convert.
• Press Shift + F3 simultaneously, or go to the Home tab and click on the Change Case icon in the Font section.

How to change the capitalization on Microsoft Excel?

You can use the UPPER and LOWER functions in a new cell, type:

• =LOWER(the cell you want to convert to lowercase).
• =UPPER(the cell you want to convert to uppercase).

How to change the capitalization on OpenOffice.org Writer?

• Select the text you want to change to convert.
• Click on the Format menu and select Change Case.
• Choose the type of capitalization you want.

How to change the capitalization on LibreOffice Writer?

• Select the text you want to change to convert.
• Go to Format > Text > Change Case.
• Choose the type of capitalization you want.

How to change the capitalization on Firefox and Thunderbird?

You can use the Leet-Key add-on that is compatible with several versions of Firefox or Thunderbird.