AutoFilter via Keyboard

[Mark Aalyson]

After invoking the AutoFilter command for a column, I would like to reveal
and select the choices using the keyboard. Does anyone know if this is
possible? I've assigned a keyboard command to the Data > Filter > AutoFilter
command, but, instead of having to use the mouse to click the resulting
arrow, I'd like to control it with the keyboard. Any ideas?

 

[JE McGimpsey]

After invoking the AutoFilter command for a column, I would like to reveal
and select the choices using the keyboard. Does anyone know if this is
possible? I've assigned a keyboard command to the Data > Filter > AutoFilter
command, but, instead of having to use the mouse to click the resulting
arrow, I'd like to control it with the keyboard. Any ideas?

From XL2004 Help ("Microsoft Excel keyboard shortcuts"):

OPTION+DOWN ARROW Display the AutoFilter list...for the selected cell

etc...

 

[Mark Aalyson]

Right there in front of my face. Thanks for pointing it out.