Data Filter Keystrokes

[Guest]

Is it possible to use keystrokes to control the data filter drop down
lists/selections in Excel? I have never figured out how to do this.

Thanks.

 

[Guest]

Select the column heading and press ALT+down arrow

 

[Guest]

Your are welcome. I have been helping a person with a disability go
"mouse-less" so the topic came up recently.

 

[Guest]

This may not help for filters, but for Data Validation dropdowns use:
ALT-DOWN

 

[Guest]

Just tested it - works for data filters, too. Thanks a ton!

 

[icsonu]

I want to find out a Specific Word in a Column after I have applied a filter
to specific Column.

Column A Column B
Apple 100$
Apricot 120$
Banana 90$
*
*
*
And So On.

I want to display "Apple" in Cell C45 after I apply the filter to Column A
for Apple.

Regards
Sonu