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

M

Mary

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.
 
D

David Biddulph

Mary said:
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.
Click to expand...

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
 
J

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.
Click to expand...

Rgds
 
J

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