Start using Searchable Drop Down List in Excel

Excel's new searchable drop-down list feature lets you quickly find items in long lists by typing part of the item's name. This feature is available in the latest versions of Office 365.

To set it up, create a list of items you want in the drop-down. Then, select the cell where you want the drop-down, go to the Data tab, and click on Data Validation. Choose List from the options and enter the range of your list items in the Source box.

When you click on the drop-down list and start typing, Excel will filter the list to show only items that match your input. This makes finding and selecting the item you need easier, especially on long lists.

This improvement, introduced in early 2022, enhances efficiency and user experience by reducing the time spent scrolling through lists. Ensure your Excel is updated to the latest version to use this option.

----------------------------------------------------------------------------------------------------------

#ExcelTips #LearnExcel #ExcelTutorial #Excel

About ExcelChamps: The ExcelChamps YouTube Channel is part of the ExcelChamps Blog, which helps people learn Microsoft Excel by providing high-quality blog posts. On the ExcelChamps YouTube Channel, we provide videos of the same quality to make education more accessible to people.

[excelchamps]

Make sure to Leave a comment on the video to share your thoughts on this. Do let me know if you have this feature in your Excel. And which Excel version you are using?

[daleanderson]

Thanks for the video. I have Microsoft 365 and this feature is included. It certainly has potential!

[gracedeman]

Thank you very much! I'm using 2010 at home, 2013 at job 1 & the latest at job 2, so I'll definitely get to use these tips at some point. 😁

[rajeevgosavi]

Great function. I have office 365 and I have received this update.

[elizabethabraham]

Am having Excel 2016. I do have this feature.

[bsa]

Only available in MS 365. You don't need the validation data list in a table, for the drop down list simply go, say ten rows past the last entry in the validation list, the blanks will not show in the drop down list, but when you enter a new category it will update the drop down list.