Home

filter by strikethrough

%3CLINGO-SUB%20id%3D%22lingo-sub-363951%22%20slang%3D%22en-US%22%3Efilter%20by%20strikethrough%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363951%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20filter%20an%20Excel%20file%2C%20showing%20those%20cells%20that%20contain%20strikethrough%20text.%20I%20cannot%20find%20a%20way%20to%20do%20this%2C%20even%20in%20Advanced.%20How%20should%20I%20do%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20Professional%20Plus%202013%20(32%20bit)%2C%20Win%2064%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-363951%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363960%22%20slang%3D%22en-US%22%3ERe%3A%20filter%20by%20strikethrough%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363960%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHere%20are%203%20methods%20how%20to%20do%20that%26nbsp%3B%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%3CA%20href%3D%22https%3A%2F%2Ftrumpexcel.com%2Ffilter-bold-font-formatting-in-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftrumpexcel.com%2Ffilter-bold-font-formatting-in-excel%2F%3C%2FA%3E%3C%2FFONT%3E.%20Samples%20are%20for%20the%20bold%20text%2C%20but%20you%20case%20is%20identical.%20If%20Get.Cell%20first%20parameter%20will%20be%2023%20instead%20of%2020%26nbsp%3B%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.mrexcel.com%2Fforum%2Fexcel-questions%2F20611-info-only-get-cell-arguments.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.mrexcel.com%2Fforum%2Fexcel-questions%2F20611-info-only-get-cell-arguments.html%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
C V Horie
New Contributor

I want to filter an Excel file, showing those cells that contain strikethrough text. I cannot find a way to do this, even in Advanced. How should I do it?

 

Excel Professional Plus 2013 (32 bit), Win 64


Thank you

1 Reply

Hi,

 

Here are 3 methods how to do that https://trumpexcel.com/filter-bold-font-formatting-in-excel/. Samples are for the bold text, but you case is identical. If Get.Cell first parameter will be 23 instead of 20 https://www.mrexcel.com/forum/excel-questions/20611-info-only-get-cell-arguments.html

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies