Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2004

    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.

    Any solution?

    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts