Hi

It works exactly the same as XL2003 for me, provided my active cell is
within the range of the list where the deletion is to occur.

If the active cell is outside of the list, then what you describe can occur.

If you create a Table, InsertTable then the autofilter is automatically
applied.
Filtering and deleting then behaves as normal, whether your active cell is
within the table or outside.

--
Regards
Roger Govier



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