I wouldn't expect it to be any difference, but try this. After you have
highlighted all rows press F5, then special and select visible cells, press
enter or click OK and now try to delete to see if it works


--

Regards,

Peo Sjoblom




"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!