Change 2007 excel Autofilter back to 2003?

[jonnybrovo815]

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!

 

[Rick Rothstein]

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.

 

[jonnybrovo815]

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.

 

[Roger Govier]

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
table>Filter 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

 

[Aaron Bono]

This was driving me nuts. Doing the simple quick filtering I always do in Excel is now like doing acrobatics.

What I did was switch to Open Office. It is free and pretty much does what Excel does. And you can do the traditional simple auto filter very easily.