Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I use a formula to create a new line of text in a cell? Jon Shelton Excel Worksheet Functions 2 July 19th 06 06:00 PM
Data showing incorrectly on line chart gobonniego Charts and Charting in Excel 1 June 15th 06 07:56 PM
coloring overy other line without doing so line by line gen Excel Worksheet Functions 5 April 1st 05 10:38 PM
Unwanted blank line in cell with wrapped text bbl Excel Discussion (Misc queries) 2 February 11th 05 09:29 PM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 08:48 PM


All times are GMT +1. The time now is 01:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"