I'm running Excel 2007 on a PC at work and on my laptop at home. Both
computers are running Windows XP." When I print from Excel at work, the
"Print what" default is "Entire Workbook". When I print from excel at Home,
the "Print what" default is "Active sheet(s)". How do I change the default
for "Print what?" Excel 2003 used to default to Active sheet(s). Lots of
paper gets wasted when one accidentally prints the entire workbook.

Try clicking on the "Office Button" (top left corner with the Windows Logo),
click on "Print". When the Print window comes up, on the bottom left area,
there is the "Print What" box with the options of "Selection", "Active
sheets", "Entire workbook", and "Ignore print areas".

That should do it.

"ruddyruss" wrote:

I'm running Excel 2007 on a PC at work and on my laptop at home. Both
computers are running Windows XP." When I print from Excel at work, the
"Print what" default is "Entire Workbook". When I print from excel at Home,
the "Print what" default is "Active sheet(s)". How do I change the default
for "Print what?" Excel 2003 used to default to Active sheet(s). Lots of
paper gets wasted when one accidentally prints the entire workbook.