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? |
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? |
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? |
All times are GMT +1. The time now is 02:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com