Tog filter items 1-by-1 at a time ?

[smallxyz]

Hi,
After applying auto-filter on data, I hope to go through each filter item of a particular column one at a time, so as to take a glimpse on the resulting data.
The crude way to do so, is to mouse-check / uncheck the items on the autofilter list.
I bet there is a more smart way to do so?
( Considering the possibility of 10+ filter items )
Thanks.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Tog filter items 1-by-1 at a time
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[smallxyz]

For example, for column "Agent", there exists filter items "A", "B", "C", "D".

Is there a convenient to loop through and display 1 filter item one at a time, without going through the tedious process of checking / unchecking items on the filter list ?

That is, I hope to display filter item "A" first. After that, display only filter item "B". Same principle applies until reaching filter item "D".
But I don't want to go through the tedious process of ticking / unticking the checkboxes in filter box.

Hope I have conveyed my story clearly. Thanks.