How to Change Case of Text to All Caps, Lower and Proper in Excel 365?
Tags: changecaseoftextinex, kutoolsexceltutorial, kutools
Published: 2020-11-18 10:42:38

---
title: How to Change Case of Text to All Caps, Lower and Proper in Excel 365?
published: true
date: 2020-11-18 05:39:22 UTC
tags: ChangeCaseofTextinEx,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-change-case-of-text-to-all-caps-lower-and-proper-in-excel-365/
---

In this guide, we will show you the ways to **Change Case of Text to All Caps, Lower and Proper in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Change Case of Text to Upper case:

To change the text case to uppercase in an Excel spreadsheet, follow the below steps.

- In the below image, you can see the **input text range that contains both upper and lower cases.** We are going to change the text case to uppercase.
- First, you need to **select the range** that you want to change the text case.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-26.png)<figcaption id="caption-attachment-17522">Select the range</figcaption>

- Go to the **Kutools Tab, select** the **Text** option, **choose** the **Change Case** option.

![Select the Change Case option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-25.png)<figcaption id="caption-attachment-17523">Select the Change Case option</figcaption>

- Now, it will open the **Change Case Dialog Box**.
- **Change type –** You need to **check** the **UPPER CASE** option.
- You can preview the results in the **Preview Pane**.

![Change Case Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-25.png)<figcaption id="caption-attachment-17524">Change Case Dialog Box</figcaption>

- Finally, **hit** the **OK** button to see the result as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-21.png)<figcaption id="caption-attachment-17525">Result</figcaption>

## Steps to Change Text Case to Lower case:

You can change the case of the text to lowercase by doing the following instructions.

- You need to **select the range** that you want to convert text to lower case. In the below image, you can see the input data that are in the upper case. Let’s see how to convert them.

![Input range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-17.png)<figcaption id="caption-attachment-17526">Input range</figcaption>

- On the **Kutools Tab, select** the **Text** option, **choose** the **Change Case** option.

![Select the Change Case option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-25.png)<figcaption id="caption-attachment-17523">Select the Change Case option</figcaption>

- Now, it will open the **Change Case Dialog Box**.
- **Change type –** You need to **select** the **lower case** option.
- You can see the preview results in the **Preview Pane**.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-16.png)<figcaption id="caption-attachment-17527">Click OK button</figcaption>

- At last, you can get the result as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-14.png)<figcaption id="caption-attachment-17528">Output</figcaption>

## Change Case of Text to proper case:

If you want to convert the text case to proper case, then follow the below steps.

- The **proper case** will change the first letter in each word to upper case and change other letters to lower case.
- First, you need to **select the input range** as shown in the below screenshot.

![Input range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-14.png)<figcaption id="caption-attachment-17530">Input range</figcaption>

- Go to the **Kutools Tab, select** the **Text** option, **choose** the **Change Case** option.

![Select the Change Case option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-25.png)<figcaption id="caption-attachment-17523">Select the Change Case option</figcaption>

- Now, it will open the **Change Case Dialog Box**.
- **Change type –** In this section, you need to **select** the **Proper Case** option.
- In the **Preview pane** , you can see the results.

![Hit the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-11.png)<figcaption id="caption-attachment-17534">Hit the OK button</figcaption>

- Then, **click** the **OK** button to get the result as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-10.png)<figcaption id="caption-attachment-17535">Result</figcaption>

## Steps to Change Text Case to Sentence case:

To change the text case to sentence case in Excel, do as follows.

- You need to **select the range** from the worksheet as shown in the below image.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/11-7.png)<figcaption id="caption-attachment-17536">Input Range</figcaption>

- On the **Kutools Tab, select** the **Text** option, **choose** the **Change Case** option.

![Select the Change Case option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-25.png)<figcaption id="caption-attachment-17523">Select the Change Case option</figcaption>

- Now, it will open the **Change Case Dialog Box**.
- **Change type – ** You need to **select** the **Sentence case** option.
- Then, you can see the results in the **Preview pane**.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/12-7.png)<figcaption id="caption-attachment-17537">Click the OK button</figcaption>

- After that, **click** the **OK** button to get the output as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/13-6.png)<figcaption id="caption-attachment-17538">Output</figcaption>

## Change Case of Text to Toggle case:

If you want to change the text case to toggle case, follow the below steps.

- **Toggle case** will convert the lower case text to upper case and vice versa.
- First, you need to **select the input range** that you need to convert.

![Input](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/14-6.png)<figcaption id="caption-attachment-17539">Input</figcaption>

- Go to the **Kutools Tab, select** the **Text** option, **choose** the **Change Case** option.

![Select the Change Case option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-25.png)<figcaption id="caption-attachment-17523">Select the Change Case option</figcaption>

- Now, it will open the **Change Case Dialog Box**.
- **Change type – ** You need to **select** the **Toggle Case** option.
- You can see the preview results in the **Preview pane**.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/15-5.png)<figcaption id="caption-attachment-17540">Click the OK button</figcaption>

- Then, **click** the **OK** button to get the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/16-4.png)<figcaption id="caption-attachment-17541">Result</figcaption>

## Summary:

In this guide, you can easily learn the steps to **Change Case of Text to All Caps, Lower and Proper in Excel Office 365** using **Kutools. ** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [How to Create a Speedometer Chart in Microsoft Excel?](https://geekexcel.com/how-to-create-a-speedometer-chart-in-microsoft-excel/)
- [Validate Email Addresses in a Column or a Range of Cells in Excel](https://geekexcel.com/how-to-validate-email-addresses-in-a-column-or-a-range-of-cells-in-excel/)