View in details what filters are set

Brass Contributor

Hi all,


I suppose this is not possible, but it's worth the shot anyway.


I want to print a list after I set some filters, but I would like to see the used filters, so this is visible on the printed sheet.


So for example, when I print all orders of September and marked as finished I would like to see


Filters: Date=2022 | Status=finished


Is something like this possible?

3 Replies


Not exactly what you ask, but see if you can use this: How to display / show auto filter criteria in Excel? 

Thanks Hans, this would add the filters, I just want to see (in text) what filters are activated.

I print the reports, and I want someone to replicate the filters from the hardcopy paper.


The VBA function described in the link that I posted will display the filter criteria in cells.