1. The first step is to create a list with all the items you want in your drop-down list. You can create your list on the same sheet where you will be entering data from the drop-down list.

How to create a nested drop-down list in Excel If you want to obtain data from some existing drop-down menus or cells and display options accordingly in a different cell, here is what you can do.

Click the "Insert" button on the Developer tab and then select "Form Controls" from the drop-down menu. Click "Combo Box" and then click the cell in which you want the box to appear.