How to create drop-down list in Excel

Creating a dropdown list is easy in Excel, but the process is not obvious. Here is a summary of the steps to create a custom dropdown list in Excel:

Create a Named Range: This step is necessary to create the list we’ll be using in your dropdown list.
Add Data Validation: This is the not-so-obvious step where you’ll prime the cell for featuring a dropdown list.
Add Named Range to Data Validation:Finally, you’ll put it all together and define the source of the dropdown list (i.e. your previously Named Range).
Set Input Message for Data Validation:This step is optional. It lets you add a popup message to guide your spreadsheet users.

w3knowledge