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

microsoft excelmicrosoft-excel-2013printing

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.

Best Answer

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!!! :)

Related Question