Results 1 to 5 of 5

Thread: Page Breaks

  1. #1
    Richard
    Guest

    Page Breaks

    I have Excel 97, SR2. I have never been able to get page breaks to work. I've tried inserting them every way that is described in the "help," yet I never can get them to work. Is this a known bug in this version, or am I just doing something wrong (like trying to follow Microsoft's help instructions!)?

    Thanks.

    Richard

  2. #2
    Star Lounger
    Join Date
    Jan 2001
    Location
    Newcastle, New South Wales, Australia
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Breaks

    I do it by going into the View PageBreaks mode from Print Preview. (Make sure that you have more than one page first.)
    Then I drag the pagebreak bar to where I want it.
    I used to get into all sorts of trouble trying to insert page breaks, so this is my way out.
    Ruth

  3. #3
    Richard
    Guest

    Re: Page Breaks

    Wow, thanks. That was easy! I appreciate the help.

    Richard

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Page Breaks

    One thing I have found with pagebreaks is it makes a difference depending on what is the active cell.

    If I want to insert a horizontal page break I need to be in Column A. Being in the pagebreak view helps, but I think it's more a matter of figuring out why they aren't working the way you want them to. Unfortunately most of us don't have the time and just trip over things by trial and error.

  5. #5
    Lounger
    Join Date
    Dec 2000
    Location
    Ohio, USA
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Breaks

    Hello,
    I have found that if you use the print # pages wide, # pages high the page break does not work but if I then click the percent size for printing, the breaks then work.

Posting Permissions

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