Hi Joe

Yes, its a bit of a pain in XL 2007, as it was when they introduced,
Sort Ascending, Sort Descending in XL2003.
As Peo says, there are many advantages to the changed Autofilter in
XL2007.

One way around your problem, could be to use the following even code
pasted into the sheet where your Filters are applied.
You need to insert a row above your header row containing the Autofilter
dropdowns.
In the code I used row 1, but you can change this to whatever you want.

Now you just type into row 1 what you want for the column, and as you
hit Enter, Tab or any arrow key, the filter becomes invoked. Press
delete on that cell, and the filter is cleared and all is visible again.

Typing a* will give everything starting with "a".
Typing a?t* will bring up artic and antic and so on.
Hope this helps to not only overcome your problem, but give you an even
faster way of working.

The code and methodology was inspired by a program I saw of Peter
Grebenik, from Brooke's University, Oxford (when we attended the XL User
Conference last year), to whom I am indebted for the idea.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rownum As Long, colnum As Long
Const testrow = 1 '<====Set this to the row above your filter
rownum = Target.Row
colnum = Target.Column
If rownum < testrow Then Exit Sub
On Error Resume Next
If Cells(rownum, colnum).Value = "" Then
Selection.AutoFilter Field:=colnum
Else
Selection.AutoFilter Field:=colnum, Criteria1:=Cells(rownum,
colnum).Value
End If
On Error GoTo 0
End Sub


--
Regards

Roger Govier


"JoeNeedsExcelHelp" wrote
in message ...
How about this, Is there a shortcut to get the focus to the last
checked box?
If so I could possibly use a 3rd party macro program to get that
functionality back.

"Peo Sjoblom" wrote:

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?