How to Make a Drop Down List in Powerpoint 2013 The tutorial demonstrates 4 quick ways to create an Excel data validation list (drop-down listing) - based on a listing of values, range of cells, named range and a dynamic dropdown. It also shows how to create a dropdown from another workbook, edit and delete data validation lists. Excel driblet-down list, aka drop down box or philharmonic box, is used to enter data in a spreadsheet from a pre-defined items list. The chief purpose of using drop down lists in Excel is to limit the number of choices available for the user. Apart from that, a dropdown prevents spelling mistakes and makes information input faster. How to create a drop-down list in Excel Brand a drop-downwards list from another workbook How to set Excel data validation non working Additional options for the Excel drop-downwards box Display a message when a