Line Suddenly Appears in Excel spreadsheet
 

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.
--
ThisMike

Line Suddenly Appears in Excel spreadsheet
 

"ThisMike" wrote in message
...
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.
--
ThisMike

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.

Line Suddenly Appears in Excel spreadsheet
 

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?
--
ThisMike


"ThisMike" wrote:

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.
--
ThisMike

Line Suddenly Appears in Excel spreadsheet
 

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.

ThisMike wrote:

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?
--
ThisMike

"ThisMike" wrote:

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.
--
ThisMike

--

Dave Peterson

Line Suddenly Appears in Excel spreadsheet
 

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.

"ThisMike" wrote in message
...
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?
--
ThisMike


"ThisMike" wrote:

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.
--
ThisMike

Line Suddenly Appears in Excel spreadsheet
 

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


"Dave Peterson" wrote:

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.

ThisMike wrote:

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?
--
ThisMike

"ThisMike" wrote:

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.
--
ThisMike

--

Dave Peterson