Excel Drop Down List Auto Find
Posted on 2011-03-25
I have a drop-down list in Excel with hundreds of items available for selection.
But I cannot type the first letter and have it jump down to the first entry within the list.
For example, if I type an "f'", the list statys stationary at the first entry. It forces me to constantly manually scroll down and select the entry when I find it.
How can I fix/do this?
BTW, what is this type of feature called? I know there is a technical name for it...