How to Change Case in Excel

With Text Toolkit for Microsoft Excel

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.

  1. To run the tool in Excel, go to the Home tab and click the Text Toolkit icon:
    Click Text Toolkit.
  2. Select Change Case:

    Select Change Case.

  3. You will see the Change Case pane. Select your options and click the Change Case button:

    The Change Case pane.

  1. Select the range of cells where you want to change text case.
  2. Tick this radio button to change all words in a cell to UPPER case.
  3. Pick Lower case to get all text in your cells changed to lower case.
  4. Select Proper Case to capitalize each word and change other letters to lowercase.
  5. Choose Sentence case to capitalize the first letter of the first word in each sentence in your cells.
  6. If you tick the Enable Undo box, the Undo button will appear:
    Tick Enable Undo to be able to Undo.
    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:
    Undo the changes.

Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.