Try alt + down arrow, down arrow until you get to select all, then press
space to deselect all items,
now type the first letter until you find the item, then space to select it
then enter.

You are definitely worse off when it comes to ease of use in this department
Of course the filter is more powerful now and you can for instance filter on
colours


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

"JoeNeedsExcelHelp" wrote in
message ...
Is there a way to get the old auto filter view back in excel 2007? I want
to
be able to navigate the auto filter dropdowns via keyboard only. In older
versions of excel I would use alt+down to get the dropdown in the header.
I
could then use arrow keys or type the first letter of the info I want to
filter. I used to be able to do this to cycle through data in the old
excel
with this handy key combo. (alt+ down arrow)+(down arrow) +(enter) and
repeat
over and over. This was very quick and useful. Is there a way to do this
in
excel 2007?