View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Filter and Delete

Hi

Work on a COPY of your data first time - just in case!

Select the rows that have been filtered by choosing the row numbers at far
left right clickDelete

--
Regards
Roger Govier

"lotivbarjoh" wrote in message
...
Is there a way to delete filtered rows without deleting the unfiltered
rows.