Print each Slicer option

Hey Team,

I've recently discovered the Excel Slicer option. It works great, however I have 1252 options that I'd rather not individually select and hit print.

Google tells me this isn't an option and I have zero knowledge in writing Macros.

I have a single slicer, and then the data is shown in columns B to H. Any ideas?


Cheers,
Matt

Not sure if this will help with your problem.

https://www.excelcampus.com/pivot-ta...-filter-pages/

It works in theory, but doesn't look as pretty as the slicer pivot and I've got a header section that needs to go with it.