Dashed Line Divider

[Ethan]

Hi, I have a Workbook that is displaying one dashed line
column divider and one dashed line row divider on all
worksheets. What do these dashed lines signify and how
can I hide(remove) them?

Thanks,
Ethan

 

[Jay]

Hi, I have a Workbook that is displaying one dashed line
column divider and one dashed line row divider on all
worksheets. What do these dashed lines signify and how
can I hide(remove) them?

Most likely, Excel is showing you where page breaks will be when printing.
To be sure, use
View >> Page break preview
or
File >> Print preview
and compare with where the dashed lines are.

Hopefully, with this knowledge, the dashed lines won't bother you any more.
They don't show up on the printed copy, I presume.

 

[Guest]

-----Original Message-----


Most likely, Excel is showing you where page breaks will be when printing.
To be sure, use
View >> Page break preview
or
File >> Print preview
and compare with where the dashed lines are.

Hopefully, with this knowledge, the dashed lines won't bother you any more.
They don't show up on the printed copy, I presume.
.

Yes, Thats it! I was able to hide them by going to Tools

Options > View > Un-check "Page breaks".

Thanks,
Ethan