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.

Read 56 Excel tips every user should master and the tutorials how to add a condition to a drop down list in Excel, how to add color to a drop down list in Excel, how to change an Excel conditional ...

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.