Excel - How do I delete filtered out rows?

[rook]

I want to quickly delete unwanted rows from a file. I can use a custom
filter to "hide" the unwanted rows, but I'd like to delete those rows.

Any suggestions.

[bpeltzer]

Instead of hiding the unwanted rows, filter to show ONLY those rows. Then
select and delete the visible rows.

"rook" wrote:

> I want to quickly delete unwanted rows from a file. I can use a custom
> filter to "hide" the unwanted rows, but I'd like to delete those rows.
>
> Any suggestions.

[Pete]

You need to choose a filter option which displays only the unwanted
rows (i.e. the opposite of what you have now). Then highlight the rows
which are visible and Edit | Delete Row.

Pete