- Select all your data
- Press CTRL+F and search for “<<DATA WHICH YOU ARE TRYING TO DELETE>>”
- Click on “Find all” button
- Now, 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)
- Select “Entire row”
- Click ok
- Job Done!
Courtesy: chandoo.org - 'Excel'lent Blog