Data Validation Smart Type

%3CLINGO-SUB%20id%3D%22lingo-sub-1441694%22%20slang%3D%22en-US%22%3EData%20Validation%20Smart%20Type%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1441694%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20data%20validation%20list%3A%26nbsp%3B%20when%20users%20are%20access%20the%20file%20through%20SharePoint%20(office%20365)%2C%20they%20can%20start%20typing%20a%20topic%20and%20the%20validation%20returns%20a%20short%20list%20based%20on%20the%20keyword.%20When%20users%20have%20the%20sheet%20open%20in%20the%20desk%20app%2C%20the%20functionality%20isn't%20the%20same.%26nbsp%3B%20How%20can%20I%20modify%20the%20settings%20so%20typing%20in%20a%20cell%20will%20short%20list%20the%20data%20validation%20results%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1441694%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1442344%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%20Smart%20Type%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1442344%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F689614%22%20target%3D%22_blank%22%3E%40LisaT2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20for%20sharing%2C%20I%20didn't%20know%20Excel%20Online%20has%20this%20functionality.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESo%20far%20not%20for%20the%20Excel%20Desktop%2C%20you%20may%20vote%20for%20this%20idea%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F32741524-searchable-drop-down-option%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F32741524-searchable-drop-down-option%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

@LisaT2020 

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...