50.2k views
22 votes
How to create drop down list in excel with multiple selections.

User Yuanqiu Li
by
3.2k points

1 Answer

8 votes

Answer:

elect the cell or cells you want the drop-down list to appear in.

Click on the Data tab on Excel's ribbon.

Click on the Data Validation button in the Data Tools group.

In the Data Validation dialog, in the Allow: list select List.

Click in the Source: box.

Step-by-step explanation:

User Hyunji
by
3.2k points