Excel Tips - Create Searchable Dropdown Lists | No VBA or Formulas Required | Latest Excel Versions

Hey team,
This quick video shows you how the latest versions of Excel for desktop and Excel 365 online allows for searchable dropdown lists without any VBA or formulas.

[@myneninagasivasai1414]

The best video i see in KZbin

[@CareerSolutionsforToday]

Thank you so much =) really appreciate it

[@deniz7mel]

Thanks for this video, very useful!

[@andredupreez8950]

I made a list of customers, but since the document is on a shared folder for our staff, I protected the sheet, but now my list is not searchable anymore. How can I fix this?

[@CareerSolutionsforToday]

Hey there, I made this video showing how to leave only certain cells unlocked. Try this on the searchable fields and let me know if this helps kzbin.info/www/bejne/fJnTnH-ZndBmgpo

[@rmalyami4935]

Is this video explained how to do it with adding code or not?

[@user-km8nn6br8y]

Wo_ Thanks for your sharing.

[@CareerSolutionsforToday]

Thank you so much!

[@MyKrishna123]

Nice👍

[@CareerSolutionsforToday]

Thank you for commenting =)

[@rmalyami4935]

Can i do it without coding?

[@michaelauth5533]

The dropdown is not searchable anymore. The only way it works is if you have selected the item from the list previously. is this a glitch?

[@CareerSolutionsforToday]

Which version of Excel are you using?

[@pradipareese]

​@@CareerSolutionsforToday latest one

[@balaguduru8843]

This option is need for numbers also because i have 100 bank accounts to find very difficult

[@CareerSolutionsforToday]

Thank you for the comment. Did you testing usinh it with numbers? It should work the same. Let me know =)

[@balaguduru8843]

@@CareerSolutionsforToday no not working

[@CareerSolutionsforToday]

@@balaguduru8843 Hey there, did you set the formula up to filter by your account number column as well? I tested on my end and works ok.

[@balaguduru8843]

@@CareerSolutionsforToday bro please help with this how to do i need it , i am struggling lot

[@CareerSolutionsforToday]

@@balaguduru8843 Can you paste or copy the exact formula you used in your Excel here? That way I can take a look =)

[@nayakantirajamanohar1471]

❤❤❤

[@johnp.saavedra5256]

All I made was a drop down list. How did you make it searchable?

[@CareerSolutionsforToday]

Hey there, which version of Excel are you using?

[@techvehicles2467]

@@CareerSolutionsforToday 2016

[@CareerSolutionsforToday]

@@techvehicles2467 This is a feature in the latest versions of Excel.

[@ashwin4355]

which version is used for this ?

[@CareerSolutionsforToday]

It has been established in the latest versions of Excel. I am currently working on 365 =)