Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Excel Ignores Page Breaks (97)

    When I use the Page Setup option to fit a printout to one page wide, Excel ignores my page breaks and breaks the pages where it wants to. (The breaks are before where Excel breaks so fitting is not an issue.) Is there a way to force Excel to not ignore the page breaks?

    Ronny
    Ronny Richardson

  2. #2
    New Lounger
    Join Date
    May 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Ignores Page Breaks (97)

    Page Breaks and Page Fitting are mutually exclusive features. Try naming specific ranges to print.

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel Ignores Page Breaks (97)

    When the Page Setup option is selected as "Fit to [1] page(s) wide by [1] pages tall", page breaks are ignored.

    To use page breaks down the sheet, set the option as "Fit to [1] page(s) wide" and blank the box for "by [ ] pages tall". To blank the box, select the number in the box and press the delete key. See attached graphic. (Instructions are vice versa if you want one page tall, multiple across, and your page breaks are vertical, across the sheet)
    Attached Images Attached Images
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    USA
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Ignores Page Breaks (97)

    Another choice is to set the percentage to a number less than 100%.

    That number should be small enough so that the printout only covers one page wide.

    I believe Excel will honor page breaks with this scenario.

  5. #5
    New Lounger
    Join Date
    Jan 2001
    Location
    Great Britain
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Ignores Page Breaks (97)

    As already remarked, page breaks and fitting to page don't seem to go together.

    My usual way round the problem is to set up the Fit to page (usually for width only) and click OK to leave Page Setup. Assuming the print area is already defined, if you then re-enter Page Setup, the Adjust to percentage will have been recalculated to the same scaling as the Fit to page would give. Check that instead and click OK again.

    Warning: the calculation does very occasionally go wrong - this is either a matter of the print area and print titles overlapping or of hidden columns in the print area. If and when this happens, then you need to find the appropriate Adjust to percentage by trial-and-error.

    Peter Wilkinson

Posting Permissions

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