View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default 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.