Grrrr...am I missing something?
In Excel:
- turn on AutoFilter
- select one of the column headers (which now has the dropdowns with AutoFilter enabled)
- Keyboard shortcut of [Alt] + [Down Arrow] (same shortcut for almost all combo boxes/dropdowns on all Windows systems...ever) will display the filter list so you can use the arrow keys on the keyboard to filter your table.
I found in an old thread (viewtopic.php?t=26178) something mentioned about the shortcut [Ctrl] + D. Unfortunately, this does not drop down the filter list. This shortcut drops down the "auto complete" list ("Selection List" function as it is referred to in the Customize Keyboard dialog box)...in other words, it is the list of all of the unique values in that column for you to select to set the active cell value to. This shortcut will change the value/contents of my column header, not change the filter.
Looking through the function list in the Customize Keyboard dialog box, nothing jumped out at me. Is there an equivalent function? If someone can tell me, I'll create my own shortcut.
If this function does not exist...well "COME ON NOW!!!" This seams like a pretty basic standard function. This should not require some AHK voodoo (also mentioned in above thread) to make it work.
Thanks for any help anyone can provide,
CTB