Deleting a row with a specified value

[dante19]

Hey,

I'm trying to save time from having to sort through a large excel document and manually delete rows that contain a specified value.

For example, if I want to delete the row in which the world "love" appears how would I do that efficiently?

I've tried researching the answer and most answers suggest to implement a (macro?)code however I have no idea how to do that. If someone could provide a working code with instructions that would be greatly appreciated.

FYI I'm using Excel 2003.

[JBeaucaire]

Assuming this is a database, title in row1, data in rows2 downward with no blank rows in between anywhere, then this is actually very easy to do.

1) Click on row1
2) Turn on the Data > Filter > AutoFilter
3) Use the drop down for the correct column to do a Custom filter for "contains love"
4) All the rows without "love" in that column will hide.
5) Highlight and delete all the remaining rows.
6) Turn off the autofilter


AutoFilter is one of those "game-changing" features, once you start fiddling with it and see all it can help you with, many things change for you, for the better.