Data Filter Keystrokes
 

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.

Data Filter Keystrokes
 

Select the column heading and press ALT+down arrow


"Paul B" wrote:

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.

Data Filter Keystrokes
 

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

Data Filter Keystrokes
 

This may not help for filters, but for Data Validation dropdowns use:
ALT-DOWN
--
Gary''s Student
gsnu200712

Data Filter Keystrokes
 

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

"Gary''s Student" wrote:

This may not help for filters, but for Data Validation dropdowns use:
ALT-DOWN
--
Gary''s Student
gsnu200712

To Find Display Text after Filter Keystrokes
 

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