View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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 wrote in message
...
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.