Dec 03 2020 11:37 PM - edited Dec 03 2020 11:38 PM
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.
Many thanks.
K
Dec 04 2020 07:39 AM
Hey @Khanh_Mai,
You can filter by any of the criteria by checking the box next to the items you want:
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.
I hope this answers your question!
Dec 04 2020 07:47 AM
Are you trying to apply an easier filtering method for future searches? I recommend creating a helper column next to the data
Dec 06 2020 05:46 PM
Oct 24 2021 11:02 PM
if you have long list and you don't want to scroll all ,, then do one thing is search area search your requirement and then every time select add current selection option.