Forum Discussion
Autocomplete searchable cells as you type
I want, as i type, for values to start showing based on a list of values, instead of having to type and then click on the dropdown arrow. How can i do this?
That works in Excel Online. Workaround for desktop version could be Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays) - Xelplus - Leila Gharani
- You understood what my issue is, however, that wont help the issue because i would like to not have to click the button (arrow) to show the possible values, i want to as i type, automatically values would start showing instead of having to click the button
- Unfortunately, im not working online. The file needs to be able to perform this offline
