Get Rid of Dotted Lines

[Zone]

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

 

[Guest]

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

 

[macropod]

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

 

[Tom Ogilvy]

Or significanlty easier do what the existing answer suggested:

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

--
Regards,
Tom Ogilvy

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]

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

 

[macropod]

Hi Tom,

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

Of course! Forgot about that one.

Cheers

--
macropod
[MVP - Microsoft Word]

Or significanlty easier do what the existing answer suggested:

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

--
Regards,
Tom Ogilvy

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]

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

 

[Zone]

Thank you, Tom. That did the trick. James

Or significanlty easier do what the existing answer suggested:

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

--
Regards,
Tom Ogilvy

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]

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