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.

Any solution?

Thanks