Printing Multiple Excel Worksheets to Multiple PDF Files

You can ask general questions, share opinions or advices about doPDF.
riytav
Posts: 2
Joined: Tue May 22, 2012 10:00 am

Postby riytav » Tue May 22, 2012 5:03 pm

Hi,


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.



Softland
Posts: 1439
Joined: Thu May 23, 2013 7:19 am

Postby Softland » Wed May 23, 2012 11:00 am

Hi,


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.


Thank you.



riytav
Posts: 2
Joined: Tue May 22, 2012 10:00 am

Postby riytav » Wed Sep 26, 2012 5:55 pm

Hi again,


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).



Softland
Posts: 1439
Joined: Thu May 23, 2013 7:19 am

Postby Softland » Tue Oct 09, 2012 5:21 pm

Hi,

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.




Return to “General”