Forum Discussion

John F. Davies's avatar
John F. Davies
Copper Contributor
Mar 02, 2017

Unwanted horizontal line

I have Excel 2003.

 

I have a continuous line under 7 cells, although only partly under the first and last cells. The line looks like a bottom border, but it is not because I cannot remove it with border formatting. If I remove the rows containing the line, the line jumps up a couple of rows. If I remove the columns containing the line, it's gone but so are my data and formulas. When I make a chart on top of the line, the line shows through the chart and when I copy the chart, the line comes with it. How can I remove this stupid line (which is now copied all over the place) without changing anything else on the worksheet? And also important, how do I avoid this happening again?

 

Thanks in advance for the tip, as my work colleagues don't know how to solve it.

17 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    John F. Davies wrote:

     

    The line looks like a bottom border, but it is not because I cannot remove it with border formatting.

    Perhaps it is an upper border.

     

    • John F. Davies's avatar
      John F. Davies
      Copper Contributor

      No, because it doesn't fully extend over the first and last cells. I don't think that you can make a border in only part of a cell. Anyway, if I remove all the rows at, above and below the line, the border can't jump up to occupy other rows, can it?

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor

        I could be an object.

        Try selecting it and hit the DEL-key.

         

Resources