Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() "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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2003 - Drawing a Simple Line - Dissapears | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Hyperlinking to Excel 2000 with a linked spreadsheet | Excel Discussion (Misc queries) | |||
how to change line spacing for text box in excel chart | Charts and Charting in Excel |