You know the routine: you click the little arrow on the column header, the massive dropdown menu appears, and suddenly you ...
Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...