Tags: appear, dotted, excel, feature, lines, microsoft, msdn, ordinary, print, rid, software, tia, vba, worksheet

Get Rid of Dotted Lines

On Microsoft » Microsoft Excel

4,557 words with 5 Comments; publish: Fri, 23 May 2008 01:55:00 GMT; (30646.88, « »)

After I print my worksheet, dotted lines appear on it. How can I get

rid of these, either by VBA or some ordinary Excel feature? TIA, James

All Comments

Leave a comment...

  • 5 Comments
    • Tools | Options | [View] tab - uncheck the box next to "Page breaks".

      "Zone" wrote:

      > After I print my worksheet, dotted lines appear on it. How can I get

      > rid of these, either by VBA or some ordinary Excel feature? TIA, James

      >

      #1; Fri, 23 May 2008 01:56:00 GMT
    • Hi Zone,

      The dotted lines you're referring to are probably there to show which cells

      fit within the margins for each page. You get the same effect if you do a

      print preview. To get rid of these lines, simply close & reopen the file.

      Cheers

      --

      macropod

      [MVP - Microsoft Word]

      "Zone" <jkend69315.excel.todaysummary.com.aol.com> wrote in message

      news:1165159076.281106.30110.excel.todaysummary.com.79g2000cws.googlegroups.com...

      > After I print my worksheet, dotted lines appear on it. How can I get

      > rid of these, either by VBA or some ordinary Excel feature? TIA, James

      >

      #2; Fri, 23 May 2008 01:57:00 GMT
    • Or significanlty easier do what the existing answer suggested:

      Tools | Options | [View] tab - uncheck the box next to "Page breaks".

      --

      Regards,

      Tom Ogilvy

      "macropod" <invalid.excel.todaysummary.com.invalid.invalid> wrote in message

      news:4th5s2F13tn17U1.excel.todaysummary.com.mid.individual.net...

      > Hi Zone,

      > The dotted lines you're referring to are probably there to show which

      > cells

      > fit within the margins for each page. You get the same effect if you do a

      > print preview. To get rid of these lines, simply close & reopen the file.

      > Cheers

      > --

      > macropod

      > [MVP - Microsoft Word]

      >

      > "Zone" <jkend69315.excel.todaysummary.com.aol.com> wrote in message

      > news:1165159076.281106.30110.excel.todaysummary.com.79g2000cws.googlegroups.com...

      >> After I print my worksheet, dotted lines appear on it. How can I get

      >> rid of these, either by VBA or some ordinary Excel feature? TIA, James

      >

      #3; Fri, 23 May 2008 01:58:00 GMT
    • Hi Tom,

      Tools | Options | View & uncheck 'Page breaks'.

      Of course! Forgot about that one.

      Cheers

      --

      macropod

      [MVP - Microsoft Word]

      "Tom Ogilvy" <twogilvy.excel.todaysummary.com.msn.com> wrote in message

      news:e1wnbyzFHHA.1080.excel.todaysummary.com.TK2MSFTNGP05.phx.gbl...

      > Or significanlty easier do what the existing answer suggested:

      > Tools | Options | [View] tab - uncheck the box next to "Page breaks".

      > --

      > Regards,

      > Tom Ogilvy

      > "macropod" <invalid.excel.todaysummary.com.invalid.invalid> wrote in message

      > news:4th5s2F13tn17U1.excel.todaysummary.com.mid.individual.net...

      > > Hi Zone,

      > >

      > > The dotted lines you're referring to are probably there to show which

      > > cells

      > > fit within the margins for each page. You get the same effect if you do

      a

      > > print preview. To get rid of these lines, simply close & reopen the

      file.

      > >

      > > Cheers

      > >

      > > --

      > > macropod

      > > [MVP - Microsoft Word]

      > >

      > >

      > > "Zone" <jkend69315.excel.todaysummary.com.aol.com> wrote in message

      > > news:1165159076.281106.30110.excel.todaysummary.com.79g2000cws.googlegroups.com...

      > >> After I print my worksheet, dotted lines appear on it. How can I get

      > >> rid of these, either by VBA or some ordinary Excel feature? TIA, James

      > >>

      > >

      > >

      >

      #4; Fri, 23 May 2008 01:59:00 GMT
    • Thank you, Tom. That did the trick. James

      Tom Ogilvy wrote:

      > Or significanlty easier do what the existing answer suggested:

      > Tools | Options | [View] tab - uncheck the box next to "Page breaks".

      > --

      > Regards,

      > Tom Ogilvy

      > "macropod" <invalid.excel.todaysummary.com.invalid.invalid> wrote in message

      > news:4th5s2F13tn17U1.excel.todaysummary.com.mid.individual.net...

      > > Hi Zone,

      > >

      > > The dotted lines you're referring to are probably there to show which

      > > cells

      > > fit within the margins for each page. You get the same effect if you do a

      > > print preview. To get rid of these lines, simply close & reopen the file.

      > >

      > > Cheers

      > >

      > > --

      > > macropod

      > > [MVP - Microsoft Word]

      > >

      > >

      > > "Zone" <jkend69315.excel.todaysummary.com.aol.com> wrote in message

      > > news:1165159076.281106.30110.excel.todaysummary.com.79g2000cws.googlegroups.com...

      > >> After I print my worksheet, dotted lines appear on it. How can I get

      > >> rid of these, either by VBA or some ordinary Excel feature? TIA, James

      > >>

      > >

      > >

      #5; Fri, 23 May 2008 02:00:00 GMT