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.

  • 1
    if you can't manage to work it directly from Excel, try to export to pdf first. – Máté Juhász Oct 13 '15 at 6:22
  • Did you try to Ctrl select the two worksheets, open a new document, paste there and print? Else I suppose you can overcame with a little macro. – Hastur Oct 13 '15 at 7:40
  • Ctrl select worksheets (holding Ctrl and clicking on the worksheet tabs) and then copy them to single new worksheet? I tried and did not work. So far, export to PDF seems to be the easiest way. – Colin Fukai Oct 16 '15 at 1:33

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.