Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a Lexmark printer which is set by default to print 2-sided in the
printer properties. However, if I print a workbook containing several worksheets to that printer, and when the printer dialogue comes up, change the print setting to 1-sided. the setting applies only to the first worksheet, and then reverts back to 2-sided for all subsequent worksheets. Seems that each worksheet is viewed as a separate print job - how do I send all worksheets to the printer at once and print 1-sided? This is a network printer, shared by many, so I cannot change the printer properties permanentlly. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
When you print make sure the option "Print Entire Workbook" is checked
instead of the default "active sheets". This only affects what you print and is only temporary has to be checked whenever you print. "Calgarybudget" wrote: I have a Lexmark printer which is set by default to print 2-sided in the printer properties. However, if I print a workbook containing several worksheets to that printer, and when the printer dialogue comes up, change the print setting to 1-sided. the setting applies only to the first worksheet, and then reverts back to 2-sided for all subsequent worksheets. Seems that each worksheet is viewed as a separate print job - how do I send all worksheets to the printer at once and print 1-sided? This is a network printer, shared by many, so I cannot change the printer properties permanentlly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I tranfer the print settings to all worksheets? | Excel Worksheet Functions | |||
Changing printers does not correctly apply printer settings | Excel Discussion (Misc queries) | |||
Globally change print settings for several worksheets at the same | Excel Discussion (Misc queries) | |||
Can I apply page settings to all sheets in Excel? | Excel Discussion (Misc queries) | |||
How do I apply the same print settings to all sheets in a workbk | Excel Discussion (Misc queries) |