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

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?

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

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.)

Sebastian wrote:

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?

--

Dave Peterson