Results 1 to 8 of 8
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Page breaks on multiple sheets (2007)

    Hi all,

    I noticed today that one cannot insert/delete page breaks across multiple sheets. All other page setup can be performed, but not page breaks. Is there some secret to doing this or must one resort to a macro.
    TX
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Page breaks on multiple sheets (2007)

    Are you sure? In Excel 2002 it works OK (select a group of sheets, select a row, column or cell, then select Insert | Page Break).

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Page breaks on multiple sheets (2007)

    OK. That must have been a bug. On the PC at work, I was shown that it did not work. I stood there looking over the guys shoulder as he attempted to do this and it did not work. Now that you tell me this Hans, I set up a simple sheet and tried it and <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>... It works!!!

    Sorry for that! <img src=/S/blush.gif border=0 alt=blush width=15 height=15> I really don't know why the PC at work did not do this! His claim seemed legitimate!
    Regards,
    Rudi

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Page breaks on multiple sheets (2007)

    I don't know if this is the issue and I can't check 2007, but you will not add page breaks in XL2002 on the sheets that are set to "Fit to". The "Adjust to" must be set.

    If after grouping and setting the page break, you change from "fit" to Adjust" the page break will then be added where it was set...

    Steve

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Page breaks on multiple sheets (2007)

    I'd test it on his PC tomorrow. There are no reports of problems with this in the newsgroups; if this feature had been broken in Excel 2007 it would surely have been mentioned by now.

  6. #6
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Page breaks on multiple sheets (2007)

    Steve, you hit the nail on the head...

    I know for a fact that "Fit To" was in use! TX for that solution!!
    Regards,
    Rudi

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Page breaks on multiple sheets (2007)

    TX Hans...

    I tried this on 2007 just now on my PC. It went through. Today, I know the person was using Fit To!
    Regards,
    Rudi

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Page breaks on multiple sheets (2007)

    "Fit to" and pagebreaks are mutually exclusive tasks: only one method can be used. XL presumes that if you want to fit the page, you are telling it to set the page breaks otherwise it can not "Fit to" <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    But as I noted, it does remember where the manual page breaks are located. It essentially ignores them so they do not display when "fitting".

    Steve

Posting Permissions

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