How do I print multiple worksheets in a workbook into multiple PDF files (1 PDF file per worksheet)? I tried selecting a few active worksheets, printed it to doPDF but it only shows 1 PDF file with all the converted worksheets combined.
When you are printing from Excel please select print entire workbook and each sheet will be converted to its own PDF file. You do not need to select any certain sheets unless you specifically need those worksheets converted.
I tried the steps you provided but it doesnt work. It would print each sheet but it merges everything into one PDF file, with the sheets printed in multiple pages. What I want is to have multiple sheets to converted as multiple/separate PDFs file (per sheet).
Try setting a different printing option for each sheet in the excel file (i.e. change the dpi settings of each tab). This will force excel to send each sheet as a different file.