delete row depending on the value of a cell

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.
 
G

Gord Dibben

Autofilter on D for "apple"

F5>Special>Visible cells>OK

Edit>Delete>Entire row.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup and return column number 2
Cell data entering slow! 0
is it possible to understand how the purchase of 1 product might becorrellated to the purchase of an 0
Macro to select and delete levels of a document 2
COUNTIF formula? 3
Copy addition formula of non-consecutive horizontal cells 2
Copy cells to different sheet if value found 1
Averageifs - criteria is cell is not blank 1

Top