Hi, I have several columns that have drop down lists associated with them. On another sheet I have created the list of possible items for those drop down lists. It works fine if I click the drop down button and select the item I want. However, it would be great if I could just start typing in that cell and what I typed would bring up the possible matching items only in the drop down list.
Example: one column is for distributors and it has about 50 entries in the drop down.
Ace
Acme
Buffalo
Curly
Dueline
etc, etc.
When I type A I want it to narrow down the selection to only the entries that have an A anywhere in their name. In this case it would return Ace, Acme and Buffalo. The more letters I type the more it would narrow down until I see the one I want and I can select it. Is this possible with LibreOffice Calc??