How to Create a Drop-Down List in an Excel Cell

Drop-down lists in Excel 2013 and 2010 provide a list of acceptable entries for a particular cell, assisting remote users in properly filling out a form you create. If a user types in the cell rather than using the list, Excel checks the contents against the list and displays an error message if the contents aren't allowed. To display a drop-down list, you first need to enter the list items into a range of cells, and then set up data validation on the target cell.

...
A warning prompts users to select from the list of options.
credit: Image courtesy of Microsoft

Step

Enter the items you want in the drop-down list anywhere in your workbook, one per cell. Select the entire list and assign it a name in the Name Box.

...
Type and name the list options.
credit: Image courtesy of Microsoft
...
Open Data Validation.
credit: Image courtesy of Microsoft

Step

Click the cell where you want the list to appear and press "Data Validation" in the Data Tools section of the "Data" tab.

...
Select the list data.
credit: Image courtesy of Microsoft

Step

Choose "List" in the Allow box and make sure "In-cell Dropdown" is checked. Type the name you assigned your list, preceded by an equals sign, into the Source box.

...
Write a message.
credit: Image courtesy of Microsoft

Step

Enter a message on the "Input Message" tab to display a notification whenever someone clicks the cell. This message can contain any text, such as to present the list of options to users who immediately start typing in the cell rather than checking the drop-down list.

...
Create an error message.
credit: Image courtesy of Microsoft

Step

Pick an error style on the "Error Alert" tab and write a message to display if a user enters an invalid choice. The "Stop" style prevents users from entering options not on the list, whereas the "Warning" and "Information" styles allow the user to override the error.

...
Inspect the list.
credit: Image courtesy of Microsoft

Step

Click "OK" to create the list. Select the list's cell and open the drop-down menu to pick from the available options.