Link to home
Start Free TrialLog in
Avatar of walterog
walterog

asked on

Automatically print 2 pages in Excel 2010

I have a user that brought up an interesting question.  When printing in Excel 2010, is it possible to set a specific number, as the default for “printer copies.”  This user always prints 2 of everything… I’m curious to see if it’s possible to set your printer to print 2 of everything-every time.
Avatar of Fayaz
Fayaz
Flag of United Arab Emirates image

In the printer configuration, default settings you can set the nuber of printouts. But this will always print two copies, regardless from any program.  Or you can create a tempate and set the print options and open the files through the template, when printed it will print two copies.
Avatar of walterog
walterog

ASKER

Thanks for the quick response. Okay I've modified the printer configuration to print 2 copies. Now the issue is excel is changing it back on its own.

I am using windows 7, MS suite 2010. Under device and printers I am making the changes to a specific printer, I apply and it it stays. When i try to print to the printer from excel it doesn't follow through with the changes. I have to do it manually through printer properties-advance tab.

any ideas?
ASKER CERTIFIED SOLUTION
Avatar of Davy2270
Davy2270
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial