Excel - How do I delete filtered out rows?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Instead of hiding the unwanted rows, filter to show ONLY those rows. Then
select and delete the visible rows.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I delete rows based on a category? 1
delete only visible rows in filter mode 4
Excel 07 - deleting filtered items 2
Multiple Column filters 5
remove excess (unwanted) rows from the bottom of a speadsheet 3
Excel 2007 - Deleting Filtered Rows 3
Delete Filtered Rows in Excel 2007 7
Deleting filtered rows in Excel 1

Back
Top