Copy the empty box to other cells to include the drop-down menu there.

Now, spreadsheet users will be prompted to select from the drop-down menu when entering data into that cell. (Note: leave “Ignore blank” checked if you want blank cells to be allowed.) In your excel spreadsheet, select all the cells which have reference to your drop-down list (In this example, select all rows from column Answers), i.e. Select the source tab where excel will ask for the database cell to appear in the drop-down list.

Form Validation criteria choose the List option. Data Validation Dialogue box appears as follows.

In the source field, type the choices you’d like your drop down menu to include, separated by commas. To create Drop Down list in Excel, follow the below steps as shown below: Click on the Data Tab.

In the dialog box, select List from the Allow drop-down menu.

Click Data Validation in the drop-down list.

From the DATA tab, select Data Validation.

But for simple situations, it’s a great method. This method works best if you are going to create just a few cells with drop-down lists, because in order to change the choices you would have to modify every cell where it appears. The simplest way to create a drop-down list in Excel 2013/2016 involves listing the choices in a dialog box. Need to add a drop-down list to your spreadsheet? This can be useful for forms, tracking sheets, and more.

Creating drop down menu in excel 2016