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.
33 Answers
There is a solution, following the @MatheJuhasz comment:
Select the sheets you would like to print by holding CTRL and clicking on individual worksheets.
Save those as a .pdf (File->Save as ... -> Save at type:PDF)
Print .pdf on both sides, as usually.
Tadaaaa!!! :)
Had problems with the PDF not saving my Excel gridlines after creating a PDF
I copied the Excel spreadsheet to Word, which gave me gridlines and text. I then saved it as a Word document and printed it. This gave me what I wanted to then fill out the spreadsheet manually, which is what I want for recording data.
I had similar problem. Resolved it by 1. ensuring duplex print is set, selecting the required tabs, Select "Print Active Sheets" then, and this is the odd bit, select "Page Setup" then "Options" click "OK" then "OK" again, which seems like you haven't really done anything, then print. This works for me when printing duplex to a Canon Pixma.
