Excel help please - hiding rows ?

[Snow-Munki]

Hi,

Got fairly huge spreadsheet of about 3000 rows. In one of the columns say column E it will have a few words.

Now I want it so if column E has the word 'hello' in for example then it will show the entire row.

If column E does not have the word 'hello' in it will hide / move / delete that row.

Is that possible ?

All I can think of is to do conditional formatting but that's not great really !

 

[div0]

AutoFilter?

If you're litterally just looking for all the rows that have the same value in them in Column E, eg 'hello', then just use an AutoFilter.

Data - Filter - AutoFilter

 

[Snow-Munki]

perfect, thanks