What is a drop-down list used for?
Drop-downs allow people to pick an item from a list that you create. In a new worksheet, type the entries you want to appear in your drop-down list. Ideally, you'll have your list items in an Excel table .
What is drop-down list example?
A drop-down list (abbreviated drop-down, or DDL; also known as a drop-down menu, drop menu, pull-down list, picklist) is a graphical control element, similar to a list box, that allows the user to choose one value from a list.