Best way to interact with a drop down, that has multiple selections

1. Can a drop-down list have multiple selections?
2. How do I edit a drop-down list in Excel with multiple selections?

Can a drop-down list have multiple selections?

When you create a drop-down list, you can only make one selection. If you select another item, the first one is replaced with the new selection. He wanted to make multiple selections from the same drop down in such a way that the selections get added to the already present value in the cell.

How do I edit a drop-down list in Excel with multiple selections?

On the worksheet where you applied the drop-down list, select a cell that has the drop-down list. Go to Data > Data Validation. On the Settings tab, click in the Source box, and then change your list items as needed. Each item should be separated by a comma, with no spaces in between like this: Yes,No,Maybe.