Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Set default for "number of copies" on printer?
I have an excel file with 6 worksheets in it. For some reason, two of the
worksheets have a default print setting to print 100 copies at a time. The other tabs have a normal print setting of "1" copy at a time. So in other words, when I try to print from these 2 tabs, the print que is automatically set to print 100 copies. How do I set the print default quantity back down to "1" so I do not have to switch "100" to "1" everytime I print? Thanks. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Set default for "number of copies" on printer?
For each sheet you're having the problem with:
- go into File, Page Setup - go into Sheet tab - click on Options button - go into Page Layout tab - set the number of copies to 1 "Lindsay" wrote: I have an excel file with 6 worksheets in it. For some reason, two of the worksheets have a default print setting to print 100 copies at a time. The other tabs have a normal print setting of "1" copy at a time. So in other words, when I try to print from these 2 tabs, the print que is automatically set to print 100 copies. How do I set the print default quantity back down to "1" so I do not have to switch "100" to "1" everytime I print? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables - how do I change default from "count of" to "sum of" | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how do i reset the default from "general" to "number" | Excel Discussion (Misc queries) | |||
Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
How to set the default "summarized by" of a data field to "Sum"? | Excel Discussion (Misc queries) |