Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
lizzibet76
 
Posts: n/a
Default Getting rid of random white lines in Excel

There are bold white horizontal lines appearing randomly in some of my
worksheets: where I have filled a group of cells in colour, they show up.
They look like cell borders but they aren't, nor are they drawing objects,
nor rows that have been reduced in height.

Deleting the rows above/below one of the lines does not get rid of it.
Deleting the columns that it spans does seem to make it disappear - however
that will cause problems for the contents of the worksheet.

Has anyone experienced this problem and how do I get rid of it?
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

Sounds like they could be page brakes. Did you print or print preview?
Try File|PageSetUp and change Portrait to Landscape (or reverse) to see if
your lines move to another column.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"lizzibet76" wrote in message
...
There are bold white horizontal lines appearing randomly in some of my
worksheets: where I have filled a group of cells in colour, they show up.
They look like cell borders but they aren't, nor are they drawing objects,
nor rows that have been reduced in height.

Deleting the rows above/below one of the lines does not get rid of it.
Deleting the columns that it spans does seem to make it disappear -
however
that will cause problems for the contents of the worksheet.

Has anyone experienced this problem and how do I get rid of it?



  #3   Report Post  
lizzibet76
 
Posts: n/a
Default

Thanks for the suggestion, Bernard, but it's not page breaks.

The lines show up in print preview, as if they are cell borders or a drawn
object. Also, they are short - spanning a few cells - not across the page.

Any other ideas anyone?!


"Bernard Liengme" wrote:

Sounds like they could be page brakes. Did you print or print preview?
Try File|PageSetUp and change Portrait to Landscape (or reverse) to see if
your lines move to another column.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"lizzibet76" wrote in message
...
There are bold white horizontal lines appearing randomly in some of my
worksheets: where I have filled a group of cells in colour, they show up.
They look like cell borders but they aren't, nor are they drawing objects,
nor rows that have been reduced in height.

Deleting the rows above/below one of the lines does not get rid of it.
Deleting the columns that it spans does seem to make it disappear -
however
that will cause problems for the contents of the worksheet.

Has anyone experienced this problem and how do I get rid of it?




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
Does Excel have a limit on lines it will wrap in a cell? Nottme Excel Discussion (Misc queries) 4 April 5th 07 10:36 AM
Excel ALWAYS locks up-little white cross-& I need to reboot HELP! Bunky Girl Excel Discussion (Misc queries) 1 July 20th 05 04:17 PM
Can I change the "white cross" cursor in Excel to another cursor? KFEagle Excel Discussion (Misc queries) 1 May 3rd 05 08:01 PM
?? Extra blank lines in 'address' cell after exporting to Excel Hadyn Pkok Excel Discussion (Misc queries) 4 April 15th 05 11:34 PM
Can you sort text in a random order in Excel tbowden Excel Discussion (Misc queries) 3 February 1st 05 02:42 PM


All times are GMT +1. The time now is 08:52 PM.

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"