Autofilter 2007

[jblake]

Hi

In excel 2003 I could AutoFilter a load of data and then delete just
the fitered data, in 2007 it deletes all the rows in between the first
and last including non filtered data. Is there away round this?

Thanks

James

 

[Dave Peterson]

Geeze. I hope that this isn't true. But xl95 did work this way, but
xl97-xl2003 only deleted the visible rows.

You can select your range to delete
edit|goto|special|visible cells only
then delete

But can you test this once more just to make sure xl2007 behaves the way you
wrote. I'd be surprised if MS changed this behavior (again!).

 

[jblake]

Hi Dave

Looks like your bang on, you CAN do it

You can select your range to delete
edit|goto|special|visible cells only
then delete

However this doesnt seem to be the default behaviour as in 2003.

Cheers

James

 

[Nick Hodge]

Dave

You can breath again...works fine here ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Dave Peterson]

James,

If Nick isn't lying <vbg>, then you may want to try it once more.

It sounds like his version of xl2007 is working differently from yours.

 

[Nick Hodge]

Dave

I'm off to try it again............




..............No, seems fine, although first time I tried it I seemed to have
deleted it all, can't replicate again though, (about twenty tests, using
traditional dialog and built-in above average, etc, etc)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Dave Peterson]

Thanks for retesting. (I'd still be very surprised if MS broke, er, changed
this behavior (well, again!).)

Dave

I'm off to try it again............

.............No, seems fine, although first time I tried it I seemed to have
deleted it all, can't replicate again though, (about twenty tests, using
traditional dialog and built-in above average, etc, etc)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk