Below you will find a quick outline of the main advantages and drawbacks as well as the detailed step-by-step instructions for each method: On the whole, there are 4 ways to create a drop down menu in Excel using the Data Validation feature.

How to copy a dropdown into multiple cells.

Allow entering other data in a combo box.

Display a message when a cell with the dropdown is clicked.

Additional options for the Excel drop-down box.

How to fix Excel data validation not working.

Make a dropdown list from another workbook.

Apart from that, a dropdown prevents spelling mistakes and makes data input faster. The main purpose of using drop down lists in Excel is to limit the number of choices available for the user.

It also shows how to create a dropdown from another workbook, edit, copy and delete data validation lists.Įxcel drop-down list, aka drop down box or combo box, is used to enter data in a spreadsheet from a pre-defined items list. The tutorial demonstrates 4 quick ways to add a dropdown in Excel.

Insert a drop down menu in excel 2016