How do I delete filtered lines in Excel 2000?

[Nicola H]

I have applied a filter to a document, now I want to delete the filtered
lines. When I delete the lines it is also deleting the lines in between the
filter.

 

[JulieD]

Hi Nicola

select the filtered lines that you want to delete and then chose edit / go
to / click on the special button and choose visible cells only - now delete
(use edit / delete and delete the row)

Please, try this on a copy of your workbook first.

Cheers
JulieD