Show Excel column filter information in cells
- by Alex
We have a sheet with a huge number of columns and filtering is often used to navigate to the correct data. The problem is that sometimes its not obvious that the filter has been applied , the visual cue is very subtle. Is it possible to show some data via a formula or VBA about the filter inside another cell?
Something like this:
Just knowing if the filter is active would be a good help, knowing what columns have active filters applied to them would be icing on the cake. Ideally they update automatically.
I dont have ownership of the spreadsheet so cant make major changes to its structure or anything but VBA is fine.
Any ideas?
