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