+ Reply to Thread
Results 1 to 4 of 4

Back to back print of multiple sheets

  1. #1
    Registered User
    Join Date
    08-04-2019
    Location
    India
    MS-Off Ver
    2007
    Posts
    61

    Back to back print of multiple sheets

    Hi,
    I have an Excel workbook which contains 8 to 10 sheets.
    If i want to give back to back print,whether settings to be done in workbook or in printer settings?
    Because when i print back to back by making settings in my Printer,it gives one sided print only.

    Please guide.

    kdraghu

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Botswana
    MS-Off Ver
    Professional Plus 2019
    Posts
    740

    Re: Back to back print of multiple sheets

    kdraghu: it'd be in your printer settings, make sure you're using the most recent driver for your printer.

    Pete

  3. #3
    Forum Contributor
    Join Date
    01-05-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    243

    Re: Back to back print of multiple sheets

    File > Print > Settings > Print Entire Workbook

  4. #4
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,858

    Re: Back to back print of multiple sheets

    I agree with Pete that it is in the Printer Settings.

    You may want to create a second copy of your printer with Default Two Sided Printing. This way all you have to do is select a different (virtual) printer .

    The following works for me in Windows 10:

    To create a second copy of your printer
    a. Go to [Control Panel] -> [Devices and Printers] or equivalent
    b. Right Click on your original printer > Printer Properties > Ports
    Write down the Port used by your original printer
    c. Go to [Control Panel] -> [Devices and Printers] and select [Add a Printer]
    d. Now select [Add a local printer]
    e. Select the set port of your printer in [Choose a printer port], use the same port as your existing printer
    f. In [Install the printer driver] select your printers Manufacturer and Model
    g. [Next]
    h. In [Which version of the driver do you want to use?] select [Use the driver that is currently installed]
    i. Enter a name for this new printer reference in [Type a printer name .e.g .'Brother Hl-L2320D Duplex']
    j. Set the Default for 2-sided printing.

    Lewis

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula to bring back cell accross multiple sheets
    By ddarko77 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-18-2015, 10:46 AM
  2. Replies: 1
    Last Post: 03-11-2015, 07:27 AM
  3. Searching Sheet1 from other sheets, and reporting back multiple results.
    By Mjones in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-14-2012, 06:47 PM
  4. [SOLVED] Counting Number of Times a Value is Repeated REPEATEDLY (Back to Back)
    By patrickfshield in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-06-2012, 04:45 AM
  5. Referencing from multiple sheets back to sheet1
    By troth in forum Excel General
    Replies: 6
    Last Post: 02-25-2011, 12:02 PM
  6. Print Sheets front to back
    By maui1girl in forum Excel General
    Replies: 2
    Last Post: 12-02-2007, 07:20 PM
  7. Reporting back a cell value using SUMIF (multiple sheets)
    By bumpcity76 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-17-2006, 06:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1