var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Page Breaks shrinks unnecessary rows/columns
I want to add a page break after row “TOTAL TRAILING 3 MONTHS” before “PHOTO TRAILING 12 MONTHS”
The first file shows the size it should look.
The second file also shows the rows that I would like to have on the second sheet.
The first step is to set all columns to Auto fit. Then, set
PageSetup.FitToPagesWide = 1
PageSetup.FitToPagesTall = 2
Then the size looks good.
The see the full view, I use Print Preview
Once I open the View/Page break preview, everything on the first page becomes smaller.