How to Delete Rows Not Containing Certain Text in Excel

Excel is a strong tool for efficiently managing and analysing massive amounts of data. You may find yourself dealing with a spreadsheet with many rows, and you only want to save the ones that fit certain criteria.

In this tutorial, we will walk you through the process of eliminating rows in Excel that do not include specific text. Whether you're a student, a professional, or simply someone who wants to clean up their data, this course will provide you the knowledge and skills you need to succeed. We'll go over several approaches, including using Excel's built−in functions and filters to rapidly detect and delete unneeded rows.

By the end of this tutorial, you'll know how to quickly filter your data and remove rows that don't include certain content, saving you time and effort. So let's get started and discover how to clean up your Excel spreadsheets by eliminating rows that don't meet your criteria!

Deleting Rows Not Containing Certain Text

Here we will first use a filter, then delete the rows to complete the task. So let us see a simple process to know how you can delete rows not containing certain text in Excel.

Step 1

Consider an Excel sheet where you have a list of items similar to the below image.

First, select the range of cells, then click on Filter under Data.

Select cells > Data > Filter.

Step 2

Then, click on the arrow and deselect only those values you do want to keep, then click OK.

Arrow > Check box > Ok.

Step 3

Then select the range of filtered cells, right−click on data, select Delete Row, and click Ok.

Select cells > Right click > Delete Row.

Step 4

Then remove the filter to complete the task.

Data > Filter.


In this tutorial, we have used a simple example to demonstrate how you can delete rows not containing certain text in Excel to highlight a particular set of data.

Updated on: 20-Jul-2023

1K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started