Autofilter functionality
 

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

Autofilter functionality
 

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 wrote:

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

Autofilter functionality
 

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" wrote:

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 wrote:

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

Autofilter functionality
 

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)

Paul Mugleston wrote:

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" wrote:

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 wrote:

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


--

Dave Peterson