Forum Discussion
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 ...
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.
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?
I could be an object.
Try selecting it and hit the DEL-key.
The line is not selectable. It is a line looking the same as a border line and is positioned exactly on the gridline between two rows. It does not occupy any area. If I place the cursor in the column anywhere above or below the line and insert a column, the mystery line gets longer.
Most irritating is that it shows up as a horizontal line on a chart which is placed on top of it.
