Often you may want to delete certain rows after filtering them in Excel.
Fortunately this is easy to do and the following example shows how to in practice.
Example: Delete Filtered Rows in Excel
Suppose we have the following dataset that contains information on 10 basketball players:
Suppose we would like to delete all rows that contain “Guard” in the Position column.
First, we can apply a filter to only view the rows that contain “Guard.”
To do so, click the Data tab along the top ribbon and then click the Filter button:
Then click the dropdown arrow next to Position, check the box next to Guard, then click OK:
The data will automatically be filtered to only show rows where the Position column contains “Guard”:
Next, highlight each of the rows. Then right click on any row and click Delete Row in the dropdown menu:
All of the visible rows will be deleted.
Lastly, just click the Filter button one more time to turn off the filter.
The only remaining rows will be the ones with “Forward” in the Position column:
The following tutorials explain how to perform other common tasks in Excel: