Excel Drop-down lists: quick select?

I have an Excel document pulling items from another xls as list items to populate a drop-down menu. The problem is, there are a LOT of choices. I can't find a way to quickly go to the area I want. (e.g. opening the drop-down list and pressing "b" doesn't go to the B's as it does for most normal drop-downs)

Is this possible? Or is there some way to autocomplete the drop-down once the user starts typing into it?

Answers


Go To Tools>Options - Edit And Check Enable AutoComplete For Cell

Values Move Your List Of Items Is In The Range Immediately Above The

Validation Cell. Hide The Rows Above Your Validation Cell.

taken from here:

http://www.ozgrid.com/Excel/autocomplete-validation.htm


Need Your Help

About the delivery of standard signals

c linux signals

By contrast, if multiple instances of a standard signal are delivered while that signal is currently blocked, then only one instance is queued. I think the above description ...