AutoFilter via Keyboard

M

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?
 
J

JE McGimpsey

Mark Aalyson said:
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?
Click to expand...

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

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

etc...
 
Top