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

preview_player
Показать описание
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.
Рекомендации по теме
Комментарии
Автор

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?

andredupreez
Автор

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

Kadapakuwait
Автор

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?

michaelauth
Автор

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

johnp.saavedra
Автор

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

rmalyami