Automatically print 2 pages in Excel 2010

Posted on 2011-10-06
Last Modified: 2012-05-12
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.
Question by:walterog
    LVL 10

    Expert Comment

    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.

    Author Comment

    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?
    LVL 3

    Accepted Solution

    3 Steps to follow:
    1. Set up or modify your PERSONAL.XLSB file (Google for how to set it up).

    2. Then copy the following simple macro:

    Sub PrintTwice()
           ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True
    End Sub

    3. Customize the quick access toolbar with a command related to the macro 'PrintTwice'

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    This article will show you how to use shortcut menus in the Access run-time environment.
    No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now