Line delete automaticaly

S

Simbad

Hi,

Is it possible to delete complete lines automaticaly?

I mean that for example, I want to delete all lines containing
certain word or phrase (not a single cell or a find replace), say al
lines that contain the word ''blue'', can this be done or do I have t
scroll down the entire worksheet and manually delete the lines?

Thanks
 
M

mikeyb

Hi Simbad,

If you go ...Data>Filter>AutoFilter

Then filter for the rows containing e.g. "blue" and delete these rows.

Go toggle filter off by... Data>Filter>AutoFilter

This should work I think,

Thanks
Mike
 
Top