Results 1 to 3 of 3
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    pagebreak line on all sheets (Excel 2003)

    Hi all,
    I was wondering if anyone other than me is seeing this weirdness. Why is it that the pesky pagebreak dotted vertical line appears on ALL sheets in my workbook when I print? Even if I ended up canceling the print job. It's just annoying to have to go to Tools/Options and uncheck the 'show page breaks' box for each and every sheet after I print something. Today, it actually appeared when I printed a PowerPoint document when Excel was open! How weird is that?! <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15> I even duplicated that phenomenon just now by creating a new empty workbook, then opened a PPT file, did a print and sure enough, that new Excel workbook had the dashed page break line on each of its 3 sheets.

    Is there some global thingy to turn this off? It's nuts that it affects Excel even when I'm not printing an Excel workbook. It's bad enough that I have to remove page breaks from each and every page when I do print a workbook, but to do it again even when I'm printing something else? <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>

    Deb

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

    Re: pagebreak line on all sheets (Excel 2003)

    I cannot reproduce this behavior (page breaks appearing in Excel when printing from another application) in Excel 2002 SP-3, but why do the page breaks bother you? It can be quite useful to know where the automatic page breaks fall, so that you can adjust the contents the best way for printing. Microsoft even introduced a Page Break view.

    By the way, automatic page breaks disappear when you close the workbook.

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: pagebreak line on all sheets (Excel 2003)

    hmm, ok it's just me then <img src=/S/doh.gif border=0 alt=doh width=15 height=15> I have xl2003 SP1 and it bothers me because after I print something I don't want to keep looking at the vertical lines on my beautifully designed worksheets <img src=/S/artist.gif border=0 alt=artist width=34 height=29> <img src=/S/groan.gif border=0 alt=groan width=16 height=15> I can see if they're there in print preview but after I'm done printing, they're not needed anymore. Also, if MS insists on putting them on the sheet, why all sheets even if I just print one? I know this isn't a question that can be answered... just venting.

    In other workbooks I've had to add code to remove this line after printing but this workbook doesn't have code (and I don't want to add it).

    Thnx,
    Deb

Posting Permissions

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