How do I delete filtered lines in Excel 2000?

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.

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




"Nicola H" <Nicola H@discussions.microsoft.com> wrote in message
news:7A0DE6BA-2D2E-4B6A-AFE4-A8781D853A3B@microsoft.com...
>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.