| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter 2007
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter 2007
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!). wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter 2007
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 Dave Peterson wrote: 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!). wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter 2007
Dave
You can breath again...works fine here ;-) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Dave Peterson" wrote in message ... 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!). wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter 2007
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 DTHIS www.nickhodge.co.uk "Dave Peterson" wrote in message ... 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. wrote: 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 Dave Peterson wrote: 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!). wrote: 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 -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter 2007
Thanks for retesting. (I'd still be very surprised if MS broke, er, changed
this behavior (well, again!).) Nick Hodge wrote: 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 DTHIS www.nickhodge.co.uk "Dave Peterson" wrote in message ... 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. wrote: 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 Dave Peterson wrote: 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!). wrote: 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 -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pls confirm 2007 chart redraw is up to 10 times slower than 2003 | Charts and Charting in Excel | |||
| Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
| Interaction of form controls and pictures in Excel 2007 | Excel Worksheet Functions | |||
| Excel 2007 Beta 2 chart problems | Charts and Charting in Excel | |||
| Excel 2007 - Autofilter different behaviour | Excel Discussion (Misc queries) | |||
Linear Mode
