Mysterious Line Have Appeared on My Spreadsheet!!

J

Julie P.

Hi, I was working on my Excel 97 spreadsheet, and noticed some mysterious
lines appeared after I accidentally hit the print icon. Here is a
screenshot:

http://mallology.lunarpages.com/excel.gif

The unwanted lines are under row 424, and after Columns J and M.

I do not know what these are, or how they appeared. How do I get rid of
them? Thanks!

Julie
 
J

JE McGimpsey

They indicate where your page breaks are.

Choose Tools/Options/View and uncheck the Page Breaks checkbox.
 
J

Julie P.

JE McGimpsey said:
They indicate where your page breaks are.

Choose Tools/Options/View and uncheck the Page Breaks checkbox.
Click to expand...

Thanks so much! It worked! I feel so stupid now. :)

J.
 
J

Julie P.

JE McGimpsey said:
They indicate where your page breaks are.

Choose Tools/Options/View and uncheck the Page Breaks checkbox.
Click to expand...


Actually, I want to view the page breaks, but I want to remove where they
are now. Like the two breaks after rows J amd M are way too close. How do I
do this?

Thanks!
 
E

Earl Kiosterud

julie,

Those are page breaks, either automatic (where it runs out of space on a
page, so it breaks to the next page), or manual. If manual, you can put the
cell pointer anywhere in column K or N (for thw vertical page break lines),
and click Insert. If you see "Remove page break," there's a manual page
break there. It was put there with Insert - Page break.

The dotted lines appear whenever you print, preview, or use View - Page
break preview, which cause pagination. So it puts those lines there and
leaves them.
 
J

Julie P.

Earl Kiosterud said:
julie,

Those are page breaks, either automatic (where it runs out of space on a
page, so it breaks to the next page), or manual. If manual, you can put the
cell pointer anywhere in column K or N (for thw vertical page break lines),
and click Insert. If you see "Remove page break," there's a manual page
break there. It was put there with Insert - Page break.

The dotted lines appear whenever you print, preview, or use View - Page
break preview, which cause pagination. So it puts those lines there and
leaves them.
Click to expand...


thanks Earl! I see your point now. They are not manual page breaks, although
the two vertical ones look different. Do you know why they look different?

And there really isn't a small space between the two vertical page breaks,
like I stated in my other post, since the first column is so big, and that
serves as a row heading.

But I am also wondering why column headings of columns N, O, and P are not
showing in the page preview? The only thin that shows is what is to the left
of the second vertical page break.
 
P

Peo Sjoblom

Go into page break view and drag them where you want

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
E

Earl Kiosterud

Julie,

On closer examination, I suspect that A1:M424 is your print area. That's
bounded by the larger dashed line. The smaller dotted line between column J
and K is a page break. That would explain why N, O and P aren't showing in
print or preview -- they're outside the print area. Check File - Page
Setup - Sheet tab - Print Area box.
 
Top