How do you delete filtered rows in an autofiltered list. The row.

[Guest]

When I auto filter a spreadsheet, I can't figure out how to delete or
eliminate from the sheet the filtered-out rows. So when I refilter the sheet
with new items to get rid of, the old filtered items come back. I've tried
copying the range to another file, but I always get all the old data in the
new file.

 

[Guest]

Select the rows you want to delete and click edit, delete.

 

[RagDyeR]

Select the filtered data, then:
<F5> <Special>,
Click on "Visible Cells Only", then <OK>,

Right click in the selection and choose "Copy".

Then simply navigate to an area of the sheet where there are *no* hidden
rows from the filtering, and "Paste".

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


When I auto filter a spreadsheet, I can't figure out how to delete or
eliminate from the sheet the filtered-out rows. So when I refilter the
sheet
with new items to get rid of, the old filtered items come back. I've tried
copying the range to another file, but I always get all the old data in the
new file.

 

[Guest]

Thanks Gary, but once you've filtered a spreadsheet, you can't see the rows
you want to delete.

At any rate, I think I've found the answer. An early post to this group
asked a similar question. The answer was to hit F5. That gives you the
select region choice. Wish I'd known this yesterday. I spent at least 5
hours trying to figure it out.