View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Patricia Patricia is offline
external usenet poster
 
Posts: 31
Default default number of copies

Click On the Sheet
Click On File + Page Setup
Click on the Options button
This will open your printer properties.
Somewhere in this box you can change the settings for copies (every printer
is different and you will have to look for it)
Mine is under the Advanced Tab and Paper/Output.

You will need to do this for each sheet

"Debbie Seibert" wrote:

Excel 2003 workbook with 8 worksheets. The default setting for "Number of
copies" in the File/Print... dialogue box varies for each sheet from 1 to 5.
How did I get it this way, and how do I reset the default to 1. -Debbie