How to Remove Rows Based on Cell Value in Excel?


Excel is a potent spreadsheet programme that enables users to effectively store and modify data. You could occasionally come across circumstances where you need to clean up or filter your data by deleting rows that fulfil specific requirements. When working with huge datasets or when you want to concentrate on a particular piece of information, removing rows based on cell values is a regular activity.

In this lesson, we'll show you how to remove rows that contain specific cell values using two separate techniques: Excel's built-in filtering tool and Visual Basic for Applications (VBA) programming.

Remove Rows Based on Cell Value

Here we will first use the find and replace function to select the range of cells, then delete the rows to complete the task. So let us see a simple process to know how you can remove rows based on cell values in Excel.

Step 1

Consider an Excel sheet where you have duplicate rows, similar to the below image.

First, select the range of cells, then click Ctrl + F to open the find and replace function.

Select Cells > Ctrl + F.

Step 2

Then enter text in Find What and click Find All. Then select all the values by holding the shift key.

Find What > Find All > Select Cells.

Step 3

Then right-click on any selected cell and select delete. Then click on Entire Row and click OK to complete the task.

Right-click > Delete > Entire Rows > OK.

Then you will see that rows will be deleted. This is how you can remove rows based on cell values in Excel.

Conclusion

In this tutorial, we have used a simple process to learn how you can remove rows based on cell value in Excel to highlight a particular set of data.

Updated on: 08-Sep-2023

91 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements