Excel Drop Down List

When inputting data into Excel, often you will find yourself have to type the same data into cells. And now, in Excel, you can create a drop down list for the cell, instead of typing the same data over and over again. A drop down list in Excel makes data entry easier, avoids typo error in a cell, and limit entries to certain items.

Next, I will show you how to create a drop down list step by step.

Imagine that we want to create a drop down list which contains a list of sections as below:

Now we have the source for the drop down list.

Highlight cells E2 to E10 to create a drop down list for each cell within this range.

Click the Data | Validation. A Data Validation dialog box will pop out.

Go to Settings tab. Choose List from the Allow drop down menu. Click on the icon from the Source field.

Highlight the sources from cell A1 to A18. Press Enter and click OK.

Now all of the selected cells in the Section column should have a drop down list, as below:

That’s it. Cheers!