Getting rid of 2nd Page on Print.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shadyhosta - 29 Dec 2004 14:57 GMT

My sheet is complete on one page and within the margins. For some reason
when I print it prints a second page which is blank except for the header
which repeats. There are some bordered cells past the page break on the
right. I have tried to delete these, but the borders remain. Is there an
easy way to delete out this second blank page so that it does not print??

Reply to this Message

cwilson - 29 Dec 2004 15:50 GMT

There are a few ways you could correct the problem. Set your print area by
selecting the cells you want to print and then go to File>Print Area>Set
Print Area. or Format the cells with the borders the remove the borders
(Right click over the cellwith border select Format Cell>border>none) then
File>Page Setup>Select Fit to 1 page tall by 1 page wide.

HTH
cwilson

> My sheet is complete on one page and within the margins. For some reason
> when I print it prints a second page which is blank except for the header
> which repeats. There are some bordered cells past the page break on the
> right. I have tried to delete these, but the borders remain. Is there an
> easy way to delete out this second blank page so that it does not print??

Reply to this Message

Don Guillett - 29 Dec 2004 15:50 GMT

Try deleting the rows/columns that are un-needed and then SAVE the workbook.
then try again.

Signature

Don Guillett
SalesAid Software
donaldb@281.com

Reply to this Message

Lady Layla - 30 Dec 2004 12:36 GMT

Reset the print area to include only what you want it to?

: My sheet is complete on one page and within the margins. For some reason
: when I print it prints a second page which is blank except for the header
: which repeats. There are some bordered cells past the page break on the
: right. I have tried to delete these, but the borders remain. Is there an
: easy way to delete out this second blank page so that it does not print??

Reply to this Message