How to delete entire row of data, by type of text?

Not sure if I phrased the subject of this post right.

But, I have an excel spreadsheet and the last row of fields contains a list of email addresses in one of the columns.

There are some email addresses that are bad, an I need to find a way where I can delete an entire field of data. Right now, I have been manually deleting the entire row of data, if the email in the email field is no longer valid. But I have over 5000 columns of data, and it takes a long time.

Is there a way where I can just plugin a list of emails that are not valid, and have that entire row of data deleted, if that row has that email address?

I hope that makes sense