ways to quickly view filtered columns and which filter was applied to each column

Dear all,

I currently use excel for mac and one recurrent challenge I have is finding a quick and convenient way to display which columns are filtered, and which filter is applied to those columns. I work with datasets with hundreds of columns, and my current strategy is to turn on the filters by using Control + Shift + L, apply my filters to specific columns and then turn filters off and start over again if I wanted to change one or some of my filters since I usually forget the order of which I applied my filters and what the filters were. The toggling of the filters on and off again seems cumbersome to me and I wonder if there's a way for excel to display which columns have filters, which filter was applied, and maybe the sequence with which the filters were applied?

Looking online, my understanding is that there's no direct way of doing this in excel and one needs to apply VBA in order for this feature to work. But I don't want to do that. i want to be able to switch from one large dataset to another while being able to use this feature. I'd appreciate any ideas/tricks of getting around this problem.

Thank you so much for your time!

Anita

Yes, I certainly have. It's pretty easy to spot which columns have the funnel symbol on when you have 10-20 columns, but mine tend to have way too many columns. Freezing the top header row is useful but in this case, it still requires that scan from column to column to determine whether a filter has been applied or not.

Please let me know if you have any other clever tricks.

Thank you.

Have a play with the attached. At the moment, with the selection_change event being handled it might get resource-hungry!

ps. I've just seen you don't want to use VBA, sorry.

Dear P45cal,

Thank you for your time. Yeah, I didn't want to use VBA, but it helps for me to explore your solution and learn from it.

Thank you so much!

Anita