strange horizontal line showing accross several columns

G

Guest

Between two rows, and for the span of about 16 or so columns there is a line
that I can't get rid of.

Its not a "Border" settings, Its not a drawing line, its not a page break
line. I can't select it. If I select the entire two rows flanking this line
and delete the two rows, the line simply shifts up. So it this line was
between rows 70 and 71, it would then appear between rows 69 and 70.
Its not anything in the footer or header either!!

It prints when I print the page.

Any idea what on earth this could be?

Thanks
Thrava
 
G

Guest

i know you said it not a border but have you considered that line could be
the bottom border of the upper row or it could be the top border of the lower
row
 
D

dziw

I have the exact same problem and I cannot figure out how to solve it.
I have tried getting rid of all borders around the cells, rows,
columns, and it does nothing. You cannot delete the rows or columns
and get rid of it. I have looked for hidden formulas, hidden rows,
nothing!
 
D

Dave Peterson

And you looked for flattened objects, too?

Edit|goto|Special|objects

Do those lines get selected?

If you know you don't have any objects (pictures/buttons/checkboxes/etc) on the
worksheet, you can select them all and hit the delete key.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top