Delete All Rows that Contain a Specific Value in Excel

Add to Favorites

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.

Steps to Delete All Rows that Contain a Specific Value

  1. Go to the worksheet that contains the data.
  2. Hit Ctrl + F to open the Find and Replace window.
  3. Type the text for which you want to search.  This text can be any value in the rows that should be deleted.  In this case, I want to delete all rows that contain the word "red".
  4. Click the Find All button.
  5. If the search in step 4 did not return the desired results, click the Options > > button to access more search features.

    Adjust the search parameters on this page as desired; they are self-explanatory.
  6. Click a result from the bottom of this window and then hit Ctrl + A to select all of the results.
  7. Once you have selected the results, hit the Close button and you should notice that each cell that was located in the search is now highlighted in the worksheet.
  8. Right-click over one of these cells and select Delete.
  9. In the window that opens, click Entire row and then hit OK.
  10. That's it!

    Now, there are no more rows that contain the word "red".


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.

Question? Ask it in our Excel Forum

Downloadable Files: Excel File