Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change 2007 excel Autofilter back to 2003?
Does anyone know if there is a way to change excel's 2007 autofilter
functionality back to like excel 2003 autoflilter use to work? I need to quickly bring up like values and compare other columns based upon the filtered values and the extra clicking of the check boxes is driving me nuts! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change 2007 excel Autofilter back to 2003?
If it helps any (and if you haven't thought about it yet), you can click the
"(Select All)" entry twice to remove your current selections. -- Rick (MVP - Excel) "jonnybrovo815" wrote in message ... Does anyone know if there is a way to change excel's 2007 autofilter functionality back to like excel 2003 autoflilter use to work? I need to quickly bring up like values and compare other columns based upon the filtered values and the extra clicking of the check boxes is driving me nuts! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change 2007 excel Autofilter back to 2003?
well that doesn't help. It actually adds more steps to the process. I used
to be able to autofilter on value in a column check visually that the information in the other columns for the returned records were the same or different and then select the next value. I did this by clicking the autofilter, arrow down enter and it worked pretty fast. Now I have to uncheck select all and check the selection I want to filter on then select all then uncheck select all, or uncheck the checked value and check the next value. Is't there a way to automatically get the last checked value unchecked when selecting the next value? Or something else? Lots of extra clicks. "Rick Rothstein" wrote: If it helps any (and if you haven't thought about it yet), you can click the "(Select All)" entry twice to remove your current selections. -- Rick (MVP - Excel) "jonnybrovo815" wrote in message ... Does anyone know if there is a way to change excel's 2007 autofilter functionality back to like excel 2003 autoflilter use to work? I need to quickly bring up like values and compare other columns based upon the filtered values and the extra clicking of the check boxes is driving me nuts! . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change 2007 excel Autofilter back to 2003?
Hi Jonny
I agree that it is a PIA compared with 2003, albeit, it is more powerful. Did you realise, that if you right click an any cell within your data tableFilter you get an option to filter the table by that cells contents. That can help some times. Also, with the Data tab visible, to quickly return to removing all filters, click the clear filter button. However, I wrote a small routine called FastFilter, which allows you to filter by typing directly into a cell, without any selection form dropdowns at all. This may be of some help to you. You will find in on Dera Dalgleish's site http://www.contextures.com/excelfilesRoger.html and go to FastFilter http://www.contextures.com/Fastfilter.zip -- Regards Roger Govier jonnybrovo815 wrote: well that doesn't help. It actually adds more steps to the process. I used to be able to autofilter on value in a column check visually that the information in the other columns for the returned records were the same or different and then select the next value. I did this by clicking the autofilter, arrow down enter and it worked pretty fast. Now I have to uncheck select all and check the selection I want to filter on then select all then uncheck select all, or uncheck the checked value and check the next value. Is't there a way to automatically get the last checked value unchecked when selecting the next value? Or something else? Lots of extra clicks. "Rick Rothstein" wrote: If it helps any (and if you haven't thought about it yet), you can click the "(Select All)" entry twice to remove your current selections. -- Rick (MVP - Excel) "jonnybrovo815" wrote in message ... Does anyone know if there is a way to change excel's 2007 autofilter functionality back to like excel 2003 autoflilter use to work? I need to quickly bring up like values and compare other columns based upon the filtered values and the extra clicking of the check boxes is driving me nuts! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
Converting Excel 2007 sheet back down to Excel 2003 | Excel Programming |