Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
ThisMike
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
ThisMike
 
Posts: n/a
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
  #5   Report Post  
Posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default 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





  #6   Report Post  
Posted to microsoft.public.excel.misc
ThisMike
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Excel 2003 - Drawing a Simple Line - Dissapears SCPU173 Excel Discussion (Misc queries) 0 March 12th 06 11:48 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Hyperlinking to Excel 2000 with a linked spreadsheet LDPitsy1970 Excel Discussion (Misc queries) 0 October 12th 05 02:31 PM
how to change line spacing for text box in excel chart Anne Charts and Charting in Excel 1 October 5th 05 12:11 AM


All times are GMT +1. The time now is 06:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"