+ Reply to Thread
Results 1 to 3 of 3

Getting rid of random white lines in Excel

  1. #1
    lizzibet76
    Guest

    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. #2
    Bernard Liengme
    Guest

    Re: Getting rid of random white lines in Excel

    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" <[email protected]> wrote in message
    news:[email protected]...
    > 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. #3
    lizzibet76
    Guest

    Re: Getting rid of random white lines in Excel

    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" <[email protected]> wrote in message
    > news:[email protected]...
    > > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1