First off, type the entries you want to appear in the drop-down lists, each list in a separate column. Type the entries for the drop-down lists. This method works with all versions of Excel 2019, 2016, 2013, 2010 and earlier.

All you need is a few named ranges and the INDIRECT formula. Copy the empty box to other cells to include the drop-down menu there. Making a dependent drop-down lists in Excel is easy. 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 the source field, type the choices you’d like your drop down menu to include, separated by commas.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. To do this, you will have to create 2 named ranges - one in the source. 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. You can make a drop-down menu in Excel using a list from another workbook as the source. 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