In the dialog box, select List as the validation criteria.

Select the cell where we want the drop down list to appear.

Do learn about OFFSET function to fully understand how it works.

We’ll be using the OFFSET function to do the same. So when we enter new values, it’ll add the same in the drop down list. We can even create a dynamic drop down list in excel. You also go back to the cells and just edit their names to change the list in drop down.

A new row is added, now just add another item in the cell.

Right click and select Insert to add a new row.

To add an item in the list, just go the range of cells which the drop down is refereeing from.

It’s fairly easy to do the same, let’s see how excel drop down list works: Now let’s say you have already created a drop down, but due to reason now you wish to add more items or maybe just edit lists in excel. So if someone enters ‘north instead of ‘North’, excel will throw an error. Do note that the drop down list is case sensitive.

This will make dropdown in excel same as Method 1. All the items should be separated by a comma.

In source field, type the values instead of selecting a range.

Select list as the validation criteria.

Let’s see a different type of example for drop down list: We can do the same with just entering the data manually in the source field. In the above method, we used data from a cell range to create a list. Method 2: Creating Drop Down List Excel By Entering Data Manually If you want to have the drop down list for multiple cells then just simply copy the cell and paste it in another location.

This is how we can create a drop down list in excel. Please Note: Check the In-cell dropdown Otherwise you’ll not see the drop down and you’ll have to manually enter data. In that, enter =$A$2:$A$7 or click on source field and select the cells containing the data when we want to use in drop down. Within settings select List as the Validation criteria for the drop down list in excel.

Select the cell where we want to create the drop down list.

We have a list of data already with us as below: Let’s see how to create drop down menu in excel.

Creating Excel Dependent Drop Down List.

Allowing Non-List Entries in Drop Down List.

Drop down list in excel