Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    London, Middlesex, England
    Thanked 0 Times in 0 Posts

    Printing Problem? (2003)


    When trying to Print preview/Print an Excel table, I noticed only part of it comes in the Preview.

    Then I saw these dashed lines before & after the table.
    I guess they are the cause of this.

    1. What are they?
    2. How can I switch on/off their viewing?
    3. How can I get rid of them?

    Thanks WOPRs.


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Printing Problem? (2003)

    The dashed line is either a "hard" page break, or the boundary of the Print Area. There are also automatic page breaks; they are shown as dashed lines with smaller dashes.

    You can toggle the display of page breaks in the View tab of Tools | Options..., but Excel will redisplay them after a print/print preview.

    If the dashed line is part of the boundary of the Print Area, you can remove it by selecting File | Print Area | Clear Print Area. If this does not remove the line, it is a hard page break.

    To remove a horizontal hard page break, click in a cell immediately below the dashed line, and select Insert | Remove Page Break. (For a vertical page break, you would click in a cell immediately to the right of the dashed line.)
    You can't remove automatic page breaks.

Posting Permissions

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