How do I keep blank pages from printing at end of spreadsheet.

[Guest]

My spreadsheet is only one page. When I print, it will print blank pages
after it unless I highlight the spreadsheet and choose print-selection. How
do I keep these blank pages from printing at the end of my spreadsheet.

 

[David Biddulph]

My spreadsheet is only one page. When I print, it will print blank pages
after it unless I highlight the spreadsheet and choose print-selection.
How
do I keep these blank pages from printing at the end of my spreadsheet.

Select the bits you want to print
File/ Print Area/ Set Print Area

If you want to be sure that it's only one page, then File/ Page Setup/ Page
Fit to 1 x 1

 

[johamshason via OfficeKB.com]

Hi,

There is possibility that you would have highlighted the entire sheet or
couple of lines more and formatted them which is causing the blank pages to
print.

To solve:
Highlight all the rows after the last line of your data and click on EDIT ---

CLEAR ----> ALL. Do the same for columns.

Rgds

 

[johamshason via OfficeKB.com]

Hi,

There is possibility that you would have highlighted the entire sheet or
couple of lines more and formatted them which is causing the blank pages to
print.

To solve:
Highlight all the rows after the last line of your data and click on EDIT ---