View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
riteoh riteoh is offline
external usenet poster
 
Posts: 1
Default Excel 07 - deleting filtered items

I have a spreadsheet with some 11,000 rows of data. I have a filter on one
of the columns, and want to delete the rows that have been filtered - but
every time I do it also deletes the rows in between. How can I delete only
the filtered columns AND not leave blank rows in their place?