Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I apply print settings to all worksheets

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default How do I apply print settings to all worksheets

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I tranfer the print settings to all worksheets? Desiree Excel Worksheet Functions 2 January 9th 07 05:48 PM
Changing printers does not correctly apply printer settings [email protected] Excel Discussion (Misc queries) 0 September 13th 06 08:10 AM
Globally change print settings for several worksheets at the same JDD Excel Discussion (Misc queries) 1 June 2nd 06 07:29 PM
Can I apply page settings to all sheets in Excel? Richard S Excel Discussion (Misc queries) 4 January 25th 06 12:30 AM
How do I apply the same print settings to all sheets in a workbk Excel Print Entire Workbook Settings Excel Discussion (Misc queries) 0 September 15th 05 02:56 PM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"