I don't think you're missing anything. There are more clicks required in
the simple case. The tradeoff is that you can now filter on any number of
elements in the list, not to mention the oft-requested (not by me<g) color
filter.

--
Jim
"jsky" wrote in message
...
| Sorry you don't understand, you must not use it as often as I did.
| Very simply, when i turned on Autofilter of a spreadsheet with several
| columns, a small drop down arrow appears in column heading. The same drop
| down arrow appears now BUT in earlier versions when i click on it, the box
| which "drops down" is simply filled with the unique data elements of that
| column of the spreadsheet, plus a {blanks} choice, and Custom. All I have
to
| do is move my mouse over the unique data element and click on it and VOILA
| the spreadsheet hides all the rows that do not contain that unique data
| element.
|
| Contrast that with what I find I have do to now with Excel 2007 (unless of
| course I need to be taught some new trick which I admit I don't know.).
In
| Excel 2007, I turn on Autofilter, chose the dropdown box of the column
which
| I'd like a unique filter to be applied, and instead of floating over the
list
| of unique items and clicking on the one I want, I have to FIRST uncheck
all
| of the items by clicking on "(Select All)". Then I have to go put a check
| mark next to the unique data element which I want filtered. Then I have
to
| click on OK. That is 3 clicks when it used to just be 1.
| Help. What am I missing? Is there an easier way?
|
| Jeff
|
| "iliace" wrote:
|
| How did it work in the old version that you prefer and can't do in
| 2007?
|
|
| On Oct 30, 1:11 pm, jsky wrote:
| The autofilter feature for Excel 2007 is far more cumbersome to use
than
| previous versions. Now I have to deselect all checked boxes (i know
you can
| click select all to unclick) and then scroll down to the one item I
want to
| filter on. THat is like 2-4 MORE clicks than I had to do before.
|
| Is there any way to bring up the old way it worked? This is a step
| backwards..
|
|
|