How to create drop down list in microsoft excel
- George Apostolov
- 05 Sep 2025
Guide
Open the file you want to create a dropdown list.
Select the cells where you want the dropdown list to be displayed.
On the Excel ribbon click on "Data," and select "Data Validation."
On the Validation criteria select "List."
Click on the up arrow.
Select the cells you wish to appear on the dropdown list. Then click the down arrow.
Select the appropriate label for each employee you want to categorize.
Create your first interactive demo in minutes
No credit card required • Start building today
