Results 1 to 7 of 7
  • Thread Tools
  1. New Lounger
    Join Date
    Mar 2002
    Location
    Omaha, Nebraska, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Page break does not work in Excel (Tried in 200, XP, and 2003)

    I am instructor at the University of Nebraska at Omaha teaching an advanced Office class. On one of the assignemnts, the students are required to insert a page break. One of the students has completed the assignemnt but we cannot get the page break to work. On the attached workbook, we have created a horizontal page break at Consolidated!A7. This should make the chart print on a separate page. Excel knows the page break is there because you can remove it. The worksheet does not print correctly nor does it display the pagebreak in the Page Break Preview screen. We have tried this on multiple machine and different versions of off with the same result. Any ideas?

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    10,927
    Thanks
    11
    Thanked 279 Times in 273 Posts

    Re: Page break does not work in Excel (Tried in 200, XP, and 2003)

    You told excel to print it one page (fit to 1 page) which overrides the page break.

    Change the percentage, don't fit it.

    File - page setup -page (tab)

    Steve

  4. Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 13 Times in 13 Posts

    Re: Page break does not work in Excel (Tried in 200, XP, and 2003)

    In File | Page Setup..., the worksheet has been set to fit the printout on 1 by 1 page. This setting ignores all manual page breaks. If you set it to adjust to a percentage, the page breaks will be displayed and printed.

  5. WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    10,927
    Thanks
    11
    Thanked 279 Times in 273 Posts

    Re: Page break does not work in Excel (Tried in 200, XP, and 2003)

    Not only do Great Minds think alike, but they seem to do it at the same time.

    Steve

  6. 2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page break does not work in Excel (Tried in 200, XP, and 2003)

    although Einstein had a lot to say about the notion of 'simultaneity' of events 'occurring' thousands of miles apart.

  7. WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    10,927
    Thanks
    11
    Thanked 279 Times in 273 Posts

    Re: Page break does not work in Excel (Tried in 200, XP, and 2003)

    Einstein was more concerned (when speaking of "simultaneous") of the relative velocities of the viewer's frames-of-reference.

    Since (I assume) both Hans and I are on "Mother Earth" we should have the same frame of reference and are traveling at the same velocity. Even if the velocities were a little different (in case one of use were on a train or in a car, etc) neither of us would have made "relativistic speeds" (ca 1% of light-speed) <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Steve

  8. Super Moderator
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,507
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Page break does not work in Excel (Tried in 200, XP, and 2003)

    -John ... I float in liquid gardens
    [acronym title="Gday mate!"][/acronym] [acronym title="What up Dude?"][/acronym] UTC -7ąDS

Posting Permissions

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