Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Odd functionality | Excel Worksheet Functions | |||
Go to functionality | Excel Worksheet Functions | |||
DES Encryption functionality | Excel Worksheet Functions | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
How to publish excel sheet to web with autofilter functionality? | Excel Worksheet Functions |