If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do you set the "Print what" option
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. |
#2
|
|||
|
|||
How do you set the "Print what" option
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. |
Thread Tools | |
Display Modes | |
|
|