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