Autofilter functionality

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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?
 
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)
 
Back
Top