software

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


quot;ThisMikequot; gt; wrote in message
...
gt;I inserted a number of lines in an existing Excel spreadhseet. A line
gt; suddenly appeared at the bottom of the preceding page, which spans 2/3 of
gt; the
gt; page. What does it mean and how do I get rid of it? Thanks.
gt; --
gt; 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.
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?
--
ThisMikequot;ThisMikequot; wrote:

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

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:
gt;
gt; The line prints. That's the problem. It's not a page break. It must mean
gt; something. I'd like to know what but more important, how do I get rid of it?
gt; Can you help?
gt; --
gt; ThisMike
gt;
gt; quot;ThisMikequot; wrote:
gt;
gt; gt; I inserted a number of lines in an existing Excel spreadhseet. A line
gt; gt; suddenly appeared at the bottom of the preceding page, which spans 2/3 of the
gt; gt; page. What does it mean and how do I get rid of it? Thanks.
gt; gt; --
gt; gt; ThisMike

--

Dave Peterson

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.

quot;ThisMikequot; gt; wrote in message
...
gt; The line prints. That's the problem. It's not a page break. It must mean
gt; something. I'd like to know what but more important, how do I get rid of
gt; it?
gt; Can you help?
gt; --
gt; ThisMike
gt;
gt;
gt; quot;ThisMikequot; wrote:
gt;
gt;gt; I inserted a number of lines in an existing Excel spreadhseet. A line
gt;gt; suddenly appeared at the bottom of the preceding page, which spans 2/3 of
gt;gt; the
gt;gt; page. What does it mean and how do I get rid of it? Thanks.
gt;gt; --
gt;gt; ThisMike
I couldn't delete it. But Lasso'ing the object and then deleting the lasso'd
object worked. Thanks.
--
ThisMikequot;Dave Petersonquot; wrote:

gt; Maybe it's a shape (rectangle/text box/button???) that's been squished when you
gt; deleted some rows???
gt;
gt; Edit|goto|special|objects
gt; ok
gt;
gt; Hit the delete key -- well, if its the only object selected.
gt;
gt; Or
gt;
gt; show the Drawing toolbar.
gt; click on the arrow icon
gt; Lasso that object
gt; hit the delete key.
gt;
gt; Or
gt;
gt; Show the control toolbox toolbar
gt; hit the design mode icon
gt; then do the drawing bar stuff and lasso the object
gt; hit the delete key
gt; hit the design mode icon to get back to normal.
gt;
gt; ThisMike wrote:
gt; gt;
gt; gt; The line prints. That's the problem. It's not a page break. It must mean
gt; gt; something. I'd like to know what but more important, how do I get rid of it?
gt; gt; Can you help?
gt; gt; --
gt; gt; ThisMike
gt; gt;
gt; gt; quot;ThisMikequot; wrote:
gt; gt;
gt; gt; gt; I inserted a number of lines in an existing Excel spreadhseet. A line
gt; gt; gt; suddenly appeared at the bottom of the preceding page, which spans 2/3 of the
gt; gt; gt; page. What does it mean and how do I get rid of it? Thanks.
gt; gt; gt; --
gt; gt; gt; ThisMike
gt;
gt; --
gt;
gt; Dave Peterson
gt;