delete row depending on the value of a cell

  • Thread starter Thread starter sanyi
  • Start date Start date
S

sanyi

I'm newbie. Sorry, if this question is trivial.
In the column D in the cells there are the words "apple" or "pie".
I want to delete those rows in which the corresponding cell in column
D
contains the word "apple".
How could I do it?
Thanks.
 
Autofilter on D for "apple"

F5>Special>Visible cells>OK

Edit>Delete>Entire row.


Gord Dibben MS Excel MVP
 
Back
Top