View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Delete Filtered Rows in Excel 2007

Hi Moon

Do you use AutoFilter or do you filter in a table in excel 2007

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Moon" wrote in message ...
When I need to delete some filtered rows, In excel 2003, I will filter the
items that need to delete follow by highlight all rows then select delete
rows will do.
However in excel 2007, the same step will delete the whole content even
though the unfiltered rows.

Pls help!