Here is Fabulous way to select rows (or columns, cells, etc) in a database that contain a Key Word, and Delete Them All at Once. In our example the records you wish to delete all have the word Grohowski (who found greener pastures in another company) included in one of the cells.
Here is What You Do:
2) Type the Key Word (“Grohowski” in our example) in textbox and click the Find All button
3) Now Select an item in the list, and press Ctrl+A to select the entire list
4) Go to the Home tab, click the down-arrow on Delete (in the Cells group on the ribbon), and then click Delete Sheet Rows
5) Voila! Your unwanted records are history!
This remarkably simple trick can save you a great deal of work and help you maintain up-to-date records in your database. Try it out some time!