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 specific text 9 new

 

Delete Rows With Specific Text

Say you have data set with names in Columns A, B, and C and want to select all the 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

 

2. The Find and Replace dialog window will open. In Find what box type the value you are searching for (here, John), then click Find All.

 

delete rows specific text 3

 

3. 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

 

4. 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

 

5. 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.