Auto size a pivot table to a page size
 

Driven mad by having to resize pivot tables constantly, printing and
reprinting to ensure they fit to a page and are readable. There needs to be
some way of setting the actual print size so that you can read its printed
format in the size that it will be, with a view on how much outside of the
print area you are in relation to the actual size of a page.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Auto size a pivot table to a page size
 

does the following help?

print preview.
click setup
choose landscape or portrait
click on "fit to 1 page wide by <blank pages tall"

unless the number of displayed columns is changing all the time it
should look much the same each time you print it, just the number of
pages changes.

..and in the pivot table options untick autoformat if you want.

regards


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=573707