Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Cannot remove line on spreadsheet

  1. #1
    New Member
    Join Date
    May 2008
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Cannot remove line on spreadsheet

    I am puzzled by a thin black line (that looks like a border line) on a spreadsheet that I am unable to remove, whatever I do. It starts halfway across column B and stops just at the end of column Z.
    It is not a border line.
    It is not a page break.
    If I delete the rows it appears on it remains visible.
    It is not an object floating on top of the spreadsheet.
    Any ideas?
    Thanks.

  2. #2
    Board Regular
    Join Date
    Oct 2007
    Location
    Chester
    Posts
    480
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cannot remove line on spreadsheet

    Try: Window > Unfreeze Panes

    HTH

    Jay
    Jay says, "When in Rome, eat lions!!"

  3. #3
    New Member
    Join Date
    May 2008
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cannot remove line on spreadsheet

    It's not the freeze panes, I have the pane frozen towards the top of the sheet but this line is towards the bottom and moves up and down when I scroll.

  4. #4
    Board Regular
    Join Date
    Nov 2003
    Location
    Surrey, UK
    Posts
    555
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cannot remove line on spreadsheet

    Is it a hidden row / row with a very low height ??

  5. #5
    New Member
    Join Date
    May 2008
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cannot remove line on spreadsheet

    JimM,
    No I can confirm it's not a row with a very low row height.
    There is something else a bit strange on this sheet - whenever I delete or insert rows I get an error msg "A formula in this worksheet contains one or more invalid references - verify that your formulas contain a valid path, workbook, range name and cell reference".
    Not sure if this is relevant but I don't usually get that msg in other workbooks, even if there are errors on the sheet.
    pivotowski

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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