How do I delete filtered lines in Excel 2000?

N

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.
 
J

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
 
Top