Autofilter functionality

[Paul Mugleston]

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

 

[Dave Peterson]

Try selecting just the rows that are in the filter--nothing more.

From the posts I've read, if you select cells outside the filter in xl2007, you
get the behavior you're describing.

 

[Paul Mugleston]

I've tried that approach of selecting each row whilst holding down the
control button, and then deleting. That does indeed work, but seems a very
time consuming way and previously it worked much better in Excel 03. Is
there a reason or benefit to the new way that it operates?

 

[Dave Peterson]

I don't see a benefit.

But did you try selecting the visible rows without ctrl-clicking?

And you could select the range
hit F5 (or ctrl-g)
visible cells only
and then delete that selected range.

(until you get used to used to the new way)