How to Filter Cells with Strikethrough in a Specific Column with One Click?
Tags: filtercellswithstrik, kutools
Published: 2020-08-06 10:33:11

---
title: How to Filter Cells with Strikethrough in a Specific Column with One Click?
published: true
date: 2020-08-01 06:49:28 UTC
tags: FilterCellswithStrik,Kutools
canonical_url: https://geekexcel.com/how-to-filter-cells-with-strikethrough-in-a-specific-column-with-one-click/
---

## Filter Cells with Strikethrough in a Specific Column with One Click:

In this article, you will learn how to **Filter Cells with Strikethrough in a Specific Column with One Click** in **Excel** 365 using **Kutools**. This Kutools feature has the separate function of **Filter Strikethrough** option to finish this task.

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) is a third party plugin. It has more than 120 features, used to complete the difficult task with several clicks.


## **Filter Cells with Strikethrough in a Specific Column in Excel:**

To Filter Cells with a strikethrough in a specific column in Excel, do as follows.

- You have to select the column in which you want to filter out the cells with a strikethrough, On the **Kutools Plus** tab, select the **Special Filter** option, choose the **Filter Strikethrough** option from the menu.

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

- Now, Kutools for Excel dialog box will pop out to remind you how many cells are found with a strikethrough, Click the **Ok** button.

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

- After clicking the Ok button, the Filtered cells with a strikethrough are displayed in the spreadsheet.
- Refer to the below image.

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

## **Filter Cells with Strikethrough and Shade Font or Background color in Excel:**

If your filter cells with strikethrough and shade or background color in Excel, follow the below steps.

- Select the column that contains cells with a strikethrough, 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/08/4-1.png)

- It will display the **Special Filter dialog box**. **Choose** the **Format** option in the Filter rules section.
- Select the **Font Strikethrough** option from the drop-down list.
- **Choose Font Color or Background color** from the **Processing of results** section.
- Then, hit the **Ok** button.

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

- Now, a prompt box will pop out and you need to press the **Ok** button.

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

- Then, the filtered cells with strikethrough will be displayed as below.

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

## **Verdict:**

In the above article, you can understand the steps to **Filter Cells with Strikethrough in a Specific Column with One Click** in **Excel** 365 using **Kutools**. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Find Specific Text Strings Only in the Formulas in Excel?](https://geekexcel.com/how-to-find-specific-text-strings-only-in-the-formulas-in-excel/)
- [Change Background Color in Microsoft Excel 365](https://geekexcel.com/how-to-change-background-color-in-microsoft-excel-365/)
- [How to Insert or Display Images from URLs or File Paths in Excel?](https://geekexcel.com/how-to-insert-or-display-images-from-urls-or-file-paths-in-excel/)