Autofilter 2007

  • Thread starter Thread starter jblake
  • Start date Start date
J

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
 
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!).
 
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
Click to expand...

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

Cheers

James
 
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.
 
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
 
Thanks for retesting. (I'd still be very surprised if MS broke, er, changed
this behavior (well, again!).)



Nick said:
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
Click to expand...
 
Back
Top