Line Suddenly Appears in Excel spreadsheet

T

ThisMike

I inserted a number of lines in an existing Excel spreadhseet. A line
suddenly appeared at the bottom of the preceding page, which spans 2/3 of the
page. What does it mean and how do I get rid of it? Thanks.
 
D

Doug Kanter

ThisMike said:
I inserted a number of lines in an existing Excel spreadhseet. A line
suddenly appeared at the bottom of the preceding page, which spans 2/3 of
the
page. What does it mean and how do I get rid of it? Thanks.
Click to expand...

Assuming you see the line only on the screen, and it does not print, it's a
page break line, showing you were (during printing), one page will end and
the next will begin.
 
T

ThisMike

The line prints. That's the problem. It's not a page break. It must mean
something. I'd like to know what but more important, how do I get rid of it?
Can you help?
 
D

Dave Peterson

Maybe it's a shape (rectangle/text box/button???) that's been squished when you
deleted some rows???

Edit|goto|special|objects
ok

Hit the delete key -- well, if its the only object selected.

Or

show the Drawing toolbar.
click on the arrow icon
Lasso that object
hit the delete key.

Or

Show the control toolbox toolbar
hit the design mode icon
then do the drawing bar stuff and lasso the object
hit the delete key
hit the design mode icon to get back to normal.
 
D

Doug Kanter

The next thing I'd check would be cells formatted with a border, even if you
don't recall formatting them this way. Could be a top border on a row, or a
bottom border on the row above. Check that.
 
T

ThisMike

I couldn't delete it. But Lasso'ing the object and then deleting the lasso'd
object worked. Thanks.
 
Top