Printing Multiple Excel Worksheets to Multiple PDF Files

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

Post by riytav »

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.


Claudiu (Softland)
Posts: 1560
Joined: Thu May 23, 2013 7:19 am

Post by Claudiu (Softland) »

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.

Follow us to stay updated:

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

Post by riytav »

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


Claudiu (Softland)
Posts: 1560
Joined: Thu May 23, 2013 7:19 am

Post by Claudiu (Softland) »

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.

Follow us to stay updated:

Post Reply