How to Add Drop-down List in Microsoft Excel

‍

‍

Here's how to do it:

‍

1. Click on the cell where you want the drop-down list.
2. Click on the "Data" tab and select "Data Validation"
3. In the dialog box, under Allow, choose "List."
4. Add Your List Items under source.
5. Select cells in Excel that already contain your list.
6. Once added click on "OK."
7. Your drop-down list will appear in the selected cell.