Category: Data Handling
When adding filter in columns, rows that don’t fit the filter condition will be hidden.
Then user can choose Worksheet: Reduce Rows...
Choose Reduce Method: Delete Hidden Rows to remove those rows.
Edit: Undo is supported.