Shrink a form to print on one page wide

  • Thread starter Thread starter Karen
  • Start date Start date
K

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?
 
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?
Click to expand...
 
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.
 
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?
Click to expand...

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.
 
Back
Top