Shrink a form to print on one page wide

[Karen]

I am trying to print a pivot table form, but the number of columns exceed the
page width in landscape. When printing the form, I want it scaled down to
fit into one page width landscape. Anyone know how to do this?

 

[golfinray]

I am trying to print a pivot table form, but the number of columns exceed the
page width in landscape. When printing the form, I want it scaled down to
fit into one page width landscape. Anyone know how to do this?

 

[Karen]

The former option doesn't exist. The latter doesn't work unfortunately. I
changed the paper size as you suggested to one that, on screen, displays more
of the columns, but when I print out on A4 it doesn't print as many as are on
screen.

 

[John W. Vinson]

I am trying to print a pivot table form, but the number of columns exceed the
page width in landscape. When printing the form, I want it scaled down to
fit into one page width landscape. Anyone know how to do this?

Don't.

Forms are for onscreen use. Print a Report instead. You have much more control
over the layout in a Report than with a Form, and you can easily specify
portrait or landscape, scale to fit, etc.