How to Create Drop-Down List in Microsoft Excel

‍

‍

Here's how to do it:

‍

1. Open the file you want to create a dropdown list.
2. Select the cells where you want the dropdown list to be displayed.
3. On the Excel ribbon click on "Data," and select "Data Validation."
4. On the Validation criteria select "List."
5. Click on the up arrow.
6. Select the cells you wish to appear on the dropdown list. Then click the down arrow.
7. Select the appropriate label for each employee you want to categorize.