Delete Filtered Rows

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I have done a complex filter, and now I want to delete
the filtered list from the worksheet. Is there a way to
do this? I know I can copy the list, but I want to
either delete or hide the rows that met my criteria.
 
Select them all, do Edit / Go To / Special / Visible cells only, then do Edit /
Delete / Entire Row
 
You must log in or register to reply here.

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

Deleting Visible Rows 4
questions on advanced filter 4
Excel 07 - deleting filtered items 2
How to delete rows in visual basic 3
Hide rows function 4
Auto Filter 3
unique records by advanced filter 10
delete only visible rows in filter mode 4

Back
Top