How do you filter strikethrough on Microsoft Excel?

One way can be using Find-replace

1. select the data
2. press Ctrl + H to open Find-Replace
3. in Find format Choose format from cell > select the cell with strike through
4. in replace format > select any fill color
5. replace all
6. then use filter by color

Your, "video" is of little practical use because it's too fast to comprehend and, as far as I can see, it can't be paused.

Actually, it is a 30 second gif image which loops continuously (so no need to pause), so it should not be difficult to follow ... still i will slow down while recording.

before the gif, i always list down the steps to be followed

the idea of putting a gif is just to give a "visual hint" as to how to go about the steps listed...most people find it useful ...

I suppose it may come down to a matter of personal preference though as to which learning medium a person prefers.

couldn't agree more.

I think you'll need a VBA function for this.

Create the following function in a module in the Visual Basic Editor:

Function IsStrikethrough(r As Range) As Boolean
Application.Volatile
IsStrikethrough = r.Font.Strikethrough
End Function

Insert a new column in your table and enter (for example) Strikethrough in the header row.

In the cell below it, enter the formula

=IsStrikethrough([@Name])

This should propagate to all rows of the table.

You can now filter the table on the Strikethrough column.

Save the workbook as a macro-enabled workbook (*.xlsm) and make sure that you allow macros when you open it.

Hello John.

Just in case you’re not familiar with the process that Hans has outlined I’ve just uploaded a single WORD file for you at:-

https://www.mediafire.com/file/91t077objxxo8v3/testing_jan_10_2022_1.docx/file

If you need the above file download it and go to the section called:-

Hans’ solution step by step

 - where I’ve given you step by step instructions including screen shots.

Dear Trip_to_tokyo,

Thanks for sharing the file link and the file here.

As the forum is public, I'd like to confirm whether the file and the file link can be shared here directly.

If yes, please add your confirmation and I'll remove the file link here to protect your privacy after 24 hours if there is no confirmation from you.

@Hans, Thanks for providing the suggestions here as well.

Thanks for your understanding.

Cliff

Cliff - of course the link and its attached file can be shared otherwise I wouldn't have posted it in the first place.

Please don't remove the link as it's intended to help John (and other possible viewers) in case he (they) doesn't (don't) know exactly how to progress Hans' proposed solution.