Question: how to select multiple value in dropdown in excel?
Answer: Select the cell or range of cells where you want the drop-down list to appear (C2 in this example).
Go to Data –> Data Tools –> Data Validation.
In the Data Validation dialogue box, within the settings tab, select 'List' as Validation Criteria.