Dashed Line Divider

E

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
 
J

Jay

Ethan said:
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.
 
G

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
 
Top