How to Filter Cells by Uppercase or Lowercase in Excel?
Tags: filtercellsbyupperca, kutools
Published: 2020-08-06 10:35:48

---
title: How to Filter Cells by Uppercase or Lowercase in Excel?
published: true
date: 2020-07-31 13:48:39 UTC
tags: Filtercellsbyupperca,Kutools
canonical_url: https://geekexcel.com/how-to-filter-cells-by-uppercase-or-lowercase-in-excel/
---

## Filter Cells by Uppercase or Lowercase in Excel:

In this article, we are going to see how to **Filter Cells by Uppercase or Lowercase in Excel** 365 using **Kutools**. Because kutools has a separate function to handle this type of task that is **Special Filter** feature.

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 special features. It is compatible with Office 2007-2019 and 365. If you want to use these features, install it from the Excel’s official website. 


## How to Filter Cells by Upper Case in Excel?

You can filter cells by uppercase in Excel using the **Special Filter** option of Kutools, do the following steps to achieve this task.

- Here, we have an example list in which we will **filter cells by upper case**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/1-10.png)

- You have to select the cells in which you want to filter cells by uppercase. On the **Kutools Plus** tab, select the **Special Filter** option, Choose the **Special Filter** option from the menu.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/5-8.png)

- It will open the **Special Filter dialog box**. Specify the range of cells in the **Range box**.
- **Check** the **Text** option under the Filter rules section.
- **Select** the **Uppercase**  **Text** from the drop-down list. Then, click the **Ok** button.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/2-13.png)

- Now, **Kutools for Excel** dialog box will pop out, you need to press the **Ok** button.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/3-12.png)

- Now, all the cells that contain Uppercase will be filtered out like the below image.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/4-12.png)

## How to Filter Cells by Lowercase in Excel?

If you want to **Filter Cells by Lowercase in Excel** , kindly follow the below instructions.

- It is similar to the above method, you need to select the cell range in which you will filter the cells by lowercase.
- Go to the **Kutools Plus** tab, select the **Special Filter** option, Choose the **Special Filter** option from the menu.
- Now, it will display the **Special Filter dialog box**. Choose the **Text** option and select the **Lowercase Text** option in the drop-down list under the **Filter rules** section.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/5-9.png)

 

- **Click** the **Ok** button. It will open the **Kutools for Excel dialog box**.
- You need to click the **Ok** button.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/6-7.png)

- Now, it will filter the cells which contain the **Lowercase** will be filtered in the table as below.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/7-6.png)

### Note:

- You can also specify the **font and background color** in the **Processing of the results** section.
- Refer to the following image.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/8-5.png)

- It will give the result as below.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/9-2.png)

- You can also select the entire rows of all filtered out cells. **Check** the **select entire row** option.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/10-1.png)

- It will give the result as below.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/11-1.png)

## Verdict:

In this article, you can understand the steps to **Filter Cells by Uppercase or Lowercase in Excel** 365 using **Kutools**. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!