Stray mark causing extra page to Print

  • Thread starter Thread starter Riccol
  • Start date Start date
R

Riccol

I have a one-page sheet I use over and over as an invoice template. It's
formatted to perfectly fit, when printed, a standard 8x11 sheet,
portrait oriented.

Somehow, I have managed to insert a stray "mark" on the sheet somewhere
which is causing it to print two pages instead of one. The first page is
the invoice, the second page is nothing but one stray mark in the
center, just a little line maybe 1/2 inch long.

In print preview, I can see page two and this stray mark in the center
of it, but I can't get rid of it.

I have tried selecting a long wide group of cells under the invoice and
clearing to remove anything that might be in them, and have also tried
using the set print area function, but neither work, it still prints the
second page with the lone stray mark.

I have been using the option to select range of pages to print and only
checking page one, but it's a PITA and half the time I forget to tell it
to only print page one.

How do I find and remove this stray mark that's causing a page two?
Thanks,
 
Hi Riccol,

go to view - page break view - then go thru page 2 and you will find where
is the stray "mark", then delete the same or resize the print area and u will
be home

click yes below, if it helps
 
Try F5>Special>Objects>OK

Does your stray mark get selected?

Can you delete it?


Gord Dibben MS Excel MVP
 
Thanks. Looking carefully at #2 in page break view, I found the culprit.
Not sure how I'd explain what was happening, but it's fixed now. Thanks
again.
 
tks for the feedback, Riccol

Riccol said:
Thanks. Looking carefully at #2 in page break view, I found the culprit.
Not sure how I'd explain what was happening, but it's fixed now. Thanks
again.
Click to expand...
 
Back
Top