Excel - How do I delete filtered out rows?
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.
|