Hiding Rows containing a Column that contains certain word

[Tracee4172]

I have a spreadsheet that in Column F there is data that could contain the words AV Temp. If it does I want to hide those rows. Report has about 1500 rows and i don't want to manually hide them.

I have tried the macro approach but it either hides every row or none.

Any suggestions?

 

[Joe4]

Welcome to the Board!

This can be done easily with Filters. Just choose the text option "Does not contain", and enter "AV Temp".