Table of Contents
Deleting filtered rows in Excel is a simple process that allows you to remove specific rows from your data set based on defined criteria. To do this, you first need to apply a filter to your data, which can be done by selecting the entire data range and clicking on the “Filter” button under the “Data” tab. Once the filter is applied, you can then select the rows you want to delete by clicking on the filter arrow next to the column header and choosing the desired criteria. Finally, right-click on any of the selected rows and click on “Delete Row” to remove them from your data set. This feature is useful for quickly removing unwanted data and organizing your spreadsheet more efficiently.
Delete Filtered Rows in Excel (With Example)
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.
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How do I delete filtered rows in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-delete-filtered-rows-in-excel/
stats writer. "How do I delete filtered rows in Excel?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-do-i-delete-filtered-rows-in-excel/.
stats writer. "How do I delete filtered rows in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-delete-filtered-rows-in-excel/.
stats writer (2024) 'How do I delete filtered rows in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-delete-filtered-rows-in-excel/.
[1] stats writer, "How do I delete filtered rows in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How do I delete filtered rows in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.