ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Unwanted line -- how to get rid of it (https://www.excelbanter.com/excel-discussion-misc-queries/106201-unwanted-line-how-get-rid.html)

[email protected]

Unwanted line -- how to get rid of it
 
I'm using Microsoft Excel 2003. There is a dashed vertical line to the
right of columns 22 and 86. It has the same color as the grid, and
cuts through merged cells. No amount of fiddling with the borders of
the columns or the cells gets rid of it. Can someone point me to
documentation that explains what it is? Thanks.

Fred


Dave Peterson

Unwanted line -- how to get rid of it
 
Maybe it's the pagebreak line.

Tools|Options|view tab|uncheck Page Breaks.

They'll come back if you print or print preview, though.

wrote:

I'm using Microsoft Excel 2003. There is a dashed vertical line to the
right of columns 22 and 86. It has the same color as the grid, and
cuts through merged cells. No amount of fiddling with the borders of
the columns or the cells gets rid of it. Can someone point me to
documentation that explains what it is? Thanks.

Fred


--

Dave Peterson

[email protected]

Unwanted line -- how to get rid of it
 

Dave Peterson wrote:
Maybe it's the pagebreak line.

Tools|Options|view tab|uncheck Page Breaks.

They'll come back if you print or print preview, though.


Indeed they are page breaks. Thanks once again, Dave.

Fred

wrote:

I'm using Microsoft Excel 2003. There is a dashed vertical line to the
right of columns 22 and 86. It has the same color as the grid, and
cuts through merged cells. No amount of fiddling with the borders of
the columns or the cells gets rid of it. Can someone point me to
documentation that explains what it is? Thanks.

Fred


--

Dave Peterson




All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com