I have been using Excel 2003 for a while and am starting to pilot 2007 for my
company, one of the spreadsheets we produces has a long list of data which
needs to have certain entried removed. In excel 2003:

Apply autofilter to header row
Filter for rows to be deleted
Select rows
Right click and select dete

This would only delete the filtered rows, however if i do this in Excel 2007
it removes anything in the range of those rows. Is there a different way to
do this or is it a bug/new way autofilter operates.

Many thanks