How to Create Drop down List in Excel

How to Create Drop down List in Excel

This post from Microsoft Excel we will tell you, how a drop down list is created in Excel, and the reason for creating a drop down list is that you want the user to select the value from this list, instead to write a value in this sheet.

We'll tell you how to easily create a drop down list in Excel.

As you can see we've listed the names of the countries in column A, and then set the same list to the drop down list.

In Column D we created the drop down list, first, you have to click on the Data Validation option in the Data tab, and then the Data Validation window opens in front of you.

The first thing to do is to select the list option.

And then at the bottom where the source is written, you have to apply the source to your list, then OK.

You see that the dropdown list option in the cell where you apply the data validation.

This way you can now easily create drop down lists in Excel.