Excel: Selecting from filter menus (keyboard only)

[tell-me-more]

Anyone know how to select a choice from filter menus in Excel without using the mouse to click on the arrow in the cell you're filtering by? Is there a keyboard shortcut?

[jordi2k]

Display the AutoFilter list for the current column select the cell that contains the column label, and then press
ALT + DOWN ARROW

Close the AutoFilter list for the current column
ALT+UP ARROW

Select the next item in the AutoFilter list
DOWN ARROW

Select the previous item in the AutoFilter list
UP ARROW

Select the first item (All) in the AutoFilter list
HOME

Select the last item in the AutoFilter list
END

Filter the list by using the selected item in the AutoFilter list
ENTER

Note: Some of these may not work in older (< 2000) versions of Excel

[tell-me-more]

Cheers Jordi. Much appreciated.