Forum Discussion
Data Validation Smart Type
I have created a data validation list: when users are access the file through SharePoint (office 365), they can start typing a topic and the validation returns a short list based on the keyword. When users have the sheet open in the desk app, the functionality isn't the same. How can I modify the settings so typing in a cell will short list the data validation results?
1 Reply
Thanks for sharing, I didn't know Excel Online has this functionality.
So far not for the Excel Desktop, you may vote for this idea here https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/32741524-searchable-drop-down-option
