Deleting all Rows which Contain a Certain Value Within Any Field of the Row in MS Excel

---

---

In this blog post I will illustrate an easy way to automatically delete all rows that contain a given value. This method does not require perusing through all records and deleting rows manually.  Consider the table below. 

Say that we want to delete all rows in which “Steve Lemme” is a cast member. Here is how to have this done using just five simple steps. 
STEP 1] Select all of the data 

STEP 2] Push “CTRL+F” and search for “Steve Lemme”

STEP 3] Select the entire search result (using Shift) and close the find box

STEP 4] Click the “Find All” button

Step 5] Push “CTRL -“ in order to have the selected rows deleted

Done! Steve Lemme is history 

---