In MS Excel 2003, I was able to set a filter, select a section of data,
highlight the rows with the data and delete them. Once I turned the filter
off, I would then see all the data I wanted.

When I do the same in MS Excel 2007, it deletes rows which have not been
selected by the filter. Instead, I have to sort the data by the value I want
to delete, delete the rows and then continue working. It works but with the
amount of data I am using the old method is much preferred.

Your advise is much appreciated. Thank you.