See all How-To Articles

How to Delete Rows if Cell Contains Specific Text in Excel

This tutorial demonstrates how to delete rows if a cell contains specific text in Excel.

 

delete rows intro

 

Delete Rows With Specific Text

Say you have data set with names in Columns A, B, and C and want to select all cells with the name John, then delete all rows containing those cells.

 

delete rows specific text 1 new

 

  1. First, select the data set (A2:C6). Then in the Ribbon, go to Home > Find & Select > Find.

 

delete rows specific text 2

 

  1. The Find and Replace dialog window opens. In Find what box, type the value you are searching for (here, John), then click Find All.
    You can also find and replace with VBA.

 

delete rows specific text 3

 

  1. The results are listed at the bottom of the Find and Replace window. Select all of them and click Close.

 

delete rows specific text 4

 

As a result, all cells with the specific value (John) are selected.

 

delete rows specific text 5 new

 

  1. To delete rows that contain these cells, right-click anywhere in the data range and from the drop-down menu, choose Delete.

 

delete rows specific text 5 new

 

  1. In the Delete dialog window, choose the Entire row and click OK.

 

delete rows specific text 7

 

As a result, all the rows with cells that contain specific text (here, John) are deleted.

 

delete rows specific text 8 new

 

Note: You can also use VBA code to delete entire rows.