If you have to delete all rows with “Devil” in it.
- Select all your data
- Press CTRL+F and search for “Devil”
- Click on “Find all” button
- Select the first result.
- Scroll down, holding SHIFT key, select the last result. This will select all search results.
- Close the Find box.
- Press CTRL + "-" (to delete cells)
