- Trending Categories
- Data Structure
- Operating System
- MS Excel
- C Programming
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
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.
Then, click on the arrow and deselect only those values you do want to keep, then click OK.
Arrow > Check box > Ok.
Then select the range of filtered cells, right−click on data, select Delete Row, and click Ok.
Select cells > Right click > Delete Row.
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.
Kickstart Your Career
Get certified by completing the courseGet Started