MS Excel Filters
 

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.

MS Excel Filters
 

Select the whole range, select "visible cells only" and delete.
Daniel

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.