How to automatically adapt the print out area of a Pivot Table?

Michael1974

New member
Joined
Mar 31, 2015
Messages
49
Reaction score
0
Points
0
Hello,

I have this attached pivot table where the Data Source content is quite large. More data the pivot table pulled out, more difficult it is to print the pivot table on the same page.

The question is how to set up the print out area to get automatically updated with the amount of data that the Pivot Table pulled out.

In order word I want the print out area to be flexible. I want a way to set up the print out area only once, to be automatically flexible. All the data must be printed on the sheet.


Thanks in advance for your help!
 

Attachments

  • Draft6.zip
    8.5 MB · Views: 9
Back
Top