How to Create Drop down List in Excel
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.
0 Comments