If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|