Getting rid of 2nd Page on Print.

[Shadyhosta]

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??

 

[cwilson]

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

 

[Don Guillett]

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

 

[Lady Layla]

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??