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!