EXCEL Page Break preview shrinks unnecessary rows/columns

[Joe1010]

Whenever I set the document to
PageSetup.FitToPagesWide = 1
PageSetup.FitToPagesTall = 2

It fills up the entire page. However, once I use the “Page Break preview” it automatically reduces the size of all rows/columns on page one, even there is still enough space on both sides of the page.

I only want to add a page break. Why does it have to make it smaller?

Any solution?

Thanks

 

[sxschech]

Did you try dragging the "blue" page divider lines up or down? Also, you could try using the scale option to adjust the % size of the reduction.

 

[Joe1010]

That’s the first thing I did. That is the page breaker.

Also, I f you use the adjust to %, you can not use the FitToPagesWide. In addition, I prefer to use the FitToPagesWide, since not all pages has the same number of columns.

Thanks

 

[sxschech]

Sorry about that. Have you tried adjusting the print margins and/or col widths, sometimes dragging a col width smaller may give it the room it needs to increase the size of the overall page.

 

[Joe1010]

I appreciate your help.
Yes. I always set the Margin to the largest as possible, as well I always use the auto fit for all columns.
Thanks

 

[Lilliabeth]

Are you saying that the printed output is tiny, or just that the view on screen (Page Break Preview) is tiny?

If you just mean the screen view is tiny: Go to Print Preview and then use the button labelled "Normal View".



Lilliabeth
-Why use a big word when a diminutive one will do?-

 

[Joe1010]

The entire output becomes smaller and all the columns becomes bigger and I need to set again the Auto fit.
Thanks