Mysterious Line Have Appeared on My Spreadsheet!!

  • Thread starter Thread starter Julie P.
  • Start date Start date
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
 
They indicate where your page breaks are.

Choose Tools/Options/View and uncheck the Page Breaks checkbox.
 
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.
 
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!
 
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.
 
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.
 
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)
 
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.
 
Earl Kiosterud said:
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.

--
Click to expand...


Thanks Earl! I actually went into Page Break Preview, and was able to click
and drag the page break lines. This seems to have solved the problem. But I
will also remember to check the print area next time too!

Julie
 
Back
Top