Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...

Whether you're applying for a role that requires Excel expertise, want to add more strings to your data analysis bow, or simply want to do more with your data in Microsoft's spreadsheet program, add ...