Create A Dropdown List In Excel

picture of create a dropdown list in excel

dd list

click inside the source field

dropdown lists are a great way to keep your data consistent

protip

as we can see in the image below i have typed in a few countries to be included in the drop down list

image titled create a drop down list in excel step

create excel dropdown

create the list

the values in the drop downs come from the array in the green border using the list selection in data validation

creating drop down lists in excel

drop down selection in excel indirect dependent dropdown list drop down selection in excel drop down selection in excel

doc create drop down list by another

how to create dropdown list excel

as we can see in the image below i have typed in a few countries to be included in the drop down list

excel table used as a data validation list source

selections from dropdowns excel

star rating example using a drop down menu

recommended article

picture of create a dropdown list in excel

create a drop down list in excel how to create a list in excel how to create lists in excel create create drop down pick list excel

enter image description here