Please help: how to select multiple filter criteria in the filter drop-down list (not select all)?

%3CLINGO-SUB%20id%3D%22lingo-sub-1955197%22%20slang%3D%22en-US%22%3EPlease%20help%3A%20how%20to%20select%20multiple%20filter%20criteria%20in%20the%20filter%20drop-down%20list%20(not%20select%20all)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1955197%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20the%20title%2C%20I%20have%20the%20very%20long%20list%20of%20filter%20criteria%20(in%20one%20column%20only)%2C%20can%20anyone%20please%20help%20me%20how%20to%20select%20multiple%20filter%20criteria%20(not%20select%20all)%3F%20Please%20see%20the%20below%20screenshot%20of%20filter%20list%20in%20my%20worksheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Khanh_Mai_0-1607067424314.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F237662iB1C32C252DADA547%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Khanh_Mai_0-1607067424314.png%22%20alt%3D%22Khanh_Mai_0-1607067424314.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EK%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1955197%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1956461%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20help%3A%20how%20to%20select%20multiple%20filter%20criteria%20in%20the%20filter%20drop-down%20list%20(not%20select%20all%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1956461%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F689194%22%20target%3D%22_blank%22%3E%40Khanh_Mai%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20filter%20by%20any%20of%20the%20criteria%20by%20checking%20the%20box%20next%20to%20the%20items%20you%20want%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%20(8).png%22%20style%3D%22width%3A%20475px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F237744i3932183E5AFE2DC6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%20(8).png%22%20alt%3D%22Screenshot%20(8).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20also%20use%20the%20search%20box%20to%20make%20filtering%20easier.%20For%20example%2C%20if%20I%20wanted%20to%20filter%20numbers%20on%20my%20list%20starting%20with%20013%2C%20I%20can%20enter%20that%20into%20the%20search%20box%20and%20check%20the%20box%20to%20add%20those%20items%20to%20my%20filter.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%20(9).png%22%20style%3D%22width%3A%20321px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F237745iDD695722C2C142FB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%20(9).png%22%20alt%3D%22Screenshot%20(9).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20answers%20your%20question!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello, 

 

As the title, I have the very long list of filter criteria (in one column only), can anyone please help me how to select multiple filter criteria (not select all)? Please see the below screenshot of filter list in my worksheet. 

Khanh_Mai_0-1607067424314.png

 

Many thanks.

 

K

 

 

3 Replies

Hey @Khanh_Mai,

 

You can filter by any of the criteria by checking the box next to the items you want:

 

Screenshot (8).png

 

You can also use the search box to make filtering easier. For example, if I wanted to filter numbers on my list starting with 013, I can enter that into the search box and check the box to add those items to my filter.

 

Screenshot (9).png

 

I hope this answers your question!

@Khanh_Mai 

Are you trying to apply an easier filtering method for future searches? I recommend creating a helper column next to the data

Hello all,
Many thanks for your advise. I also tried already. Just make sure that there is anyway to select multiples item like "SHIFT" + Left Button.
Thank you!