How do I filter columns and rows for a certain word in Excel?

S

Sebastian

I want to set up a filter so if a row has a certain word in any column, it
shows up. Is this possible? If so, how do I do it?
 
D

Dave Peterson

I would use another column and put a formula like:

=countif(a2:m2,"*" & "whateveryouwanthere" & "*")>0

Then filter on True/falses.

(And adjust that range to match your data.)
 
Top