Multiple selection with filter

1. How do I filter multiple choices in Excel?

How do I filter multiple choices in Excel?

Go to Data –> Data Tools –> Data Validation. In the Data Validation dialogue box, within the settings tab, select 'List' as Validation Criteria. In Source field, select the cells which have the items that you want in the drop down. Click OK.