How to Create a Drop-down List in Excel

Follow these simple steps to add a drop-down list in Excel. This can be very useful for creating consistent data entry with categorical data.

Step 1

Create the list of categories you’d like to feature in the dropdown. Make sure you don’t leave in blank cells in between the categories.

Step 2

Click on the cell where you want the drop-down option. Then go to Data Validation on the Data ribbon in Excel,

Step 3

The Data Validation pop-up will appear, here you will select List and then add the fields where the categories are.

Step 4

Now minimize the pop-up and then select the cells which list the categories. Then click OK

The drop-down option will show the category options.