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

[@deniz7mel]

Thanks for this video, very useful!

[@myneninagasivasai1414]

The best video i see in KZbin

[@CareerSolutionsforToday]

Thank you so much =) really appreciate it

[@MyKrishna123]

Nice👍

[@CareerSolutionsforToday]

Thank you for commenting =)

[@mengwahfong9960]

version 365 also can not

[@ananthnandh]

Search options not working.

[@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

[@nayakantirajamanohar5657]

❤❤❤

[@rmalyami4935]

Can i do it without coding?

[@Kadapakuwait44]

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 =)

[@Kadapakuwait44]

@@CareerSolutionsforToday no not working

[@CareerSolutionsforToday]

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

[@Kadapakuwait44]

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

[@CareerSolutionsforToday]

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

[@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

[@ashwin4355]

which version is used for this ?

[@CareerSolutionsforToday]

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

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

[@madjayax731]

@@CareerSolutionsforToday I am in LTSC ver and it isn't there

[@CareerSolutionsforToday]

@@madjayax731 I am sorry to hear that, not sure why it wouldn't be working.

[@rmalyami4935]

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

[@CareerSolutionsforToday]

Hey yes! You can do this without coding.

[@rickyjanitra5448]

Same .is nt work

[@CareerSolutionsforToday]

@@rickyjanitra5448 Make sure you are using the latest version of Excel =)

[@dmnjeetsingh1]

not working

[@CareerSolutionsforToday]

Hey there, which part is not working?

[@dmnjeetsingh1]

@@CareerSolutionsforToday bro i had entered 1850 items in my list list scrolling is working but not text type search im using office 2016

[@CareerSolutionsforToday]

@@dmnjeetsingh1 Gotcha, sorry for the confusion, this is available in the latest Excel versions.

[@agungainur2803]

Its not work

[@CareerSolutionsforToday]

@@agungainur2803 Which version of Excel are you using?

[@thesolution3300]

Not working