Print two arbitrary excel worksheets as one page, double-sided

12,784

There is a solution, following the @MatheJuhasz comment:


  1. Select the sheets you would like to print by holding CTRL and clicking on individual worksheets.

  2. Save those as a .pdf (File->Save as ... -> Save at type:PDF)

  3. Print .pdf on both sides, as usually.


Tadaaaa!!! :)

Share:
12,784

Related videos on Youtube

Colin Fukai
Author by

Colin Fukai

Updated on September 18, 2022

Comments

  • Colin Fukai
    Colin Fukai almost 2 years

    I have an Excel file. It contains several worksheets (ex: A, B, C, D ...). Each worksheet prints on one page in the same orientation.

    How do I quickly print any two of these worksheets (ex: A & C, B & C, etc.) as a single page, double-sided?

    If I ctrl select the two worksheet tabs and print, Excel will print just those 2 selected worksheets, but they print as separate pages even when the double-sided print option from the Excel print screen is set.