How to Delete Filtered Rows in Excel

In this tutorial, you will learn how to delete filtered rows in Excel.

You might wish to filter a large data set in an Excel spreadsheet so that you can only see particular rows. For instance, you could wish to just see the rows in column A that have the term “Error” in them. After filtering the data, you might only want to remove the filtered rows. Using a straightforward keyboard shortcut is possible.

Once ready, we’ll get started by utilizing real-world examples to show you how to delete filtered rows in Excel.

Delete Filtered Rows in Excel

Before we begin we will need a group of data to delete filtered rows in Excel.

Step 1

First, you need to have a clean and tidy group of data to work with.

Step 2

In this example, we want to extract only products that are fruits. To do so, we can simply filter the data to only show products that are fruits. We will first select the entire data group, then select ‘Filter’.

Step 3

Once you have filtered, it will show only products that are vegetables.

Step 4

Now you can highlight these rows and right-click to delete them.

Step 5

Then we will select all the criteria in the filter.

Step 6

Once we are done, the vegetable products will be deleted.