Printing

[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

 

[Dave Peterson]

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

 

[Paul Hyett]

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

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*!

 

[Dave Peterson]

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.

 

[Paul Hyett]

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.

Thanks.

 

[SiliconXu]

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.