How to Filter All Cells By Italics in Microsoft Excel 365?
Tags: filterallcellsbyital, kutools
Published: 2020-08-06 10:35:12

---
title: How to Filter All Cells By Italics in Microsoft Excel 365?
published: true
date: 2020-07-31 14:38:37 UTC
tags: Filterallcellsbyital,Kutools
canonical_url: https://geekexcel.com/how-to-filter-all-cells-by-italics-in-microsoft-excel-365/
---

## Filter All Cells By Italics in Microsoft Excel:

In this tutorial, we will guide you to learn how to **Filter All Cells By Italics** in **Excel** 365 using **Kutools**. Let’s see the special feature of kutools to do this task. That is the **Filter Italics** feature. Using that we can complete this work with several clicks.

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) is a third party plugin. You have to install it before use this.


## How to Filter All Cells by Italics in a Column?

Here we come up with the **Filter Italics** feature of Kutools to achieve this task, do the following steps.

- You have to **select any cell** in the column in which you want to filter all cells by italics.
- On the **Kutools Plus** tab, Select the **Special Filter** option, Choose the **Filter Italics** option from the drop-down list.

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

- It will display the pop-out message to show you how many cells have been found from the list. **Click** the **Ok** button to move to the next step.

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

- After clicking the Ok button, it will show the filtered cells that contain italics font in the table.
- Refer to the below image.

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

## How to Filter All Cells by Italics and Highlight with Specified Font or Background Color?

If you want to Filter all cells by italics and highlight with specified font or background color, follow the below steps.

- Go to the **Kutools** tab, select the **Special Filter** option, then choose **the Special Filter** option in the drop-down list.

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

- In the **Special Filter dialog box** , do as follows.
- **Range** – Select the Column used to filter the cells by italics.
- **Filter rules** – **Check** the **format** option and then **choose** the **Font italic** from the drop-down list.
- **Processing of results** – Choose the **Font color** and **background-color ** from the drop-down list.
- Hit the **Ok** button.

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

- It will open the Kutools for Excel dialog box, **click** the **Ok** button.

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

- Now, all the italic cells are filtered out and highlighted with the selected background color like the below screenshot.

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

## Conclusion:

In the above article, you can learn the steps to **Filter All Cells By Italics** in **Excel** 365 using **Kutools**. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!