How to Filter Strikethrough in Excel: Simple Guide

Learn how to filter strikethrough text in Excel with easy steps. Perfect for organizing data and boosting productivity in just a few clicks!

This tutorial includes:

Using Find & Replace to Filter Strikethrough Text

Filtering Strikethrough Text Using Find & Replace

Using Find & Replace, we can identify all the cells with a strikethrough format and apply a specific color to them.

Once the cells are highlighted, we can easily filter them based on the applied cell color, leveraging Excel’s built-in filter feature.

For example, in the dataset below, column A contains some cells with the strikethrough format, and our goal is to filter only those cells.

Also Read: Bollywood News by Stories

Steps to Filter Strikethrough Cells in Excel:

Begin by selecting all the cells in Column A.
Press and hold the Control (Ctrl) key, then hit the F key. This will open the Find and Replace dialog box. Alternatively, you can navigate to the Home tab, click on the Find & Select button in the Editing group, and then choose Find from the dropdown.
Once the Find and Replace box appears, click the Options button to reveal additional filtering options.

Click on the Format button to open the Find Format dialog box.

Also read : why-costco-travel-is-the-smart-way-to-explore-the-world

Navigate to the Font tab and check the Strikethrough option under the Effects section.

Click OK.
Then, click on Find All. This will display a list of all the cells with the strikethrough format applied, right below the Find and Replace dialog box. At this stage, Excel will have only selected the first cell where the strikethrough format was found.

Now, hold the Control (Ctrl) key and press the A key. This will select all the cells that have the strikethrough format applied.

Close the Find and Replace dialog box.
Then, go to the Home tab and apply a fill color to all the selected cells. For this example, let’s choose a blue color.

Right-click on any of the selected cells, go to the Filter option, and then click on Filter by Selected Cell’s Color.

And that’s it! Now, you’ll only see the cells that have strikethrough formatting.

While Excel doesn’t offer a direct option to filter strikethrough cells, we used the Find and Replace feature to locate them and then applied a color. This enabled us to utilize Excel’s built-in Filter by Color option, allowing us to filter all the cells with strikethrough formatting.

How can I filter cells with strikethrough formatting in Excel?

Excel does not have a built-in feature to directly filter strikethrough cells. However, you can use a workaround with VBA (Visual Basic for Applications) or the Find and Replace feature.

Can I undo strikethrough formatting after filtering?