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

[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?

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

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