Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does Excel have a limit on lines it will wrap in a cell? | Excel Discussion (Misc queries) | |||
Excel ALWAYS locks up-little white cross-& I need to reboot HELP! | Excel Discussion (Misc queries) | |||
Can I change the "white cross" cursor in Excel to another cursor? | Excel Discussion (Misc queries) | |||
?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
Can you sort text in a random order in Excel | Excel Discussion (Misc queries) |