With the Text Toolkit add-in for Excel, you can easily change case of text in the selected cells in your worksheet. In this manual, find out how to use the Change Case utility.
-
To run the tool in Excel, go to the Home tab and click the Text Toolkit icon:
-
Select Change Case:
-
You will see the Change Case pane. Select your options and click the Change Case button:
- Select the range of cells where you want to change text case.
- Tick this radio button to change all words in a cell to UPPER case.
- Pick Lower case to get all text in your cells changed to lower case.
- Select Proper Case to capitalize each word and change other letters to lowercase.
- Choose Sentence case to capitalize the first letter of the first word in each sentence in your cells.
- If you tick the Enable Undo box, the Undo button will appear:
As soon as you hit Change Case, the Undo button will become clickable and you'll be able to undo the changes made by the add-in:
