in a cell I have Data validation with validation criteria to Allow List.
Now my list is a long list of 3 alphabet codes such as
ACE
AET
AMN
ARC
ARM
ASL
ATG
ATS
AUG
AWI
BBC
BEL
BRG
CBS
CDA
CEC
CHT
COP
CPT
CSM
CWT
CWT
DBA
DTK
when I do a normal filter I can go from one code starting with say letter
"A" to another code starting with "D" by simply pressing "D" on the
keyboard. This does not happen in this list. Is there some way I can make it
happen.