If you don’t want to select from the Filter each item, you can combine the Filter and some formula to make it easier. So by creating a formula (or many formulas) eventually you can have a column which tells you whether that row should be kept or deleted.
Delete Unnecessary Rows in Excel with Formula help
You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.