Quickly find all rows in Excel that contain a certain value and then delete those rows.
This is a simple technique for quickly searching an entire worksheet to locate specific rows that you can then delete without having to individually search a data set and delete each row.
If you made a mistake simply hit Ctrl + Z to undo the last action and you will see the original data set again.
Make sure to download our sample spreadsheet, which accompanies this tutorial, so you can try it out yourself.