How to Add a Drop-down List in Excel

You must have seen some Excel spreadsheets with drop-down list. It’s quite convenient to select an option from the list instead of typing it by yourself. Therefore, I’d like to share some experiences of creating a drop-down list in Excel.

1. Select the cell you want to add drop-down menu. Click Data Validation in Data tab.

2. In the Validation criteria section, choose List in Allow.

3. Input the text options of drop-down list in Source. Different options should be separated by half-angle comma like the picture below.

4. Hit OK and the drop-down list has been added to the cell you select.