Printing

  • Thread starter Thread starter Bernie Beal
  • Start date Start date
B

Bernie Beal

When I print a particular single sheet Excel File, I get the
printed copy, but then the printer gives me one more blank sheet. How can I
prevent this?

Bernie Beal
 
If you do File|Print Preview, do you get the correct number of sheets displayed?

If yes, I bet it's a printer problem.

If no, I'd change the print area (File|Print area|set print area).
 
If you do File|Print Preview, do you get the correct number of sheets
displayed?

If yes, I bet it's a printer problem.

If no, I'd change the print area (File|Print area|set print area).
Click to expand...

On a related topic - is there any way of changing the default print
margins (Excel 2003)?

They're easy to set manually, but I hate having to change it *every
single time*! :(
 
Saved from a previous post:

You could create a workbook template named book.xlt and store it in your XLStart
folder. You can name the sheets whatever you want (and do other stuff, too --
print headers/footers/margins).

In xl2003, a new workbook will be created based on this workbook when you click
on the New Icon on the standard toolbar.

You could also create another template named sheet.xlt. Any new worksheet you
add to an existing workbook will inherit its setting.
 
Saved from a previous post:

You could create a workbook template named book.xlt and store it in
your XLStart
folder. You can name the sheets whatever you want (and do other stuff, too --
print headers/footers/margins).

In xl2003, a new workbook will be created based on this workbook when you click
on the New Icon on the standard toolbar.

You could also create another template named sheet.xlt. Any new worksheet you
add to an existing workbook will inherit its setting.
Click to expand...

Thanks.
 
Press "Ctrl+End" to see if there is any used range in the "blank" area.

Or you can set the print area for what you want to print.
 
Back
Top