To make a drop-down list in Excel, enter the list information in a worksheet, highlight the cells, right-click on the selection to define the name, and then select Data Validation from the Data tab. From the dialog box, customize the list options.Continue Reading
Open a new or existing worksheet, and type the entries for the list in a single row or column of cells.
Highlight the cells for the list, right-click on it, and select Define Name. Type a name without spaces in the appropriate box, and then press the OK button.
To assign a location for the drop-down list, click on a cell in the worksheet.
Navigate to the Data tab, and select Data Validation in the Data Tools group. From the Settings tab, select List from the Allow box, and in the Source box, enter an equal sign followed by the name of the list.
In the Data Validation dialog box, select Ignore Blank if it is okay to leave a cell blank, and select In-Cell Dropdown if you want the drop-down list to appear inside a cell. Navigate to the Input Message tab, and enter any message you want to appear when a cell is selected. From the Error Alert tab, select a Style option, and then type the title and message you want to appear if an incorrect cell is selected.