Printing Multiple Excel Worksheets to Multiple PDF Files

(4 posts)

riytav

Member
Joined: May '12
Posts: 2

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.

Posted 12 months ago #
Softland

Key Master
Joined: May '08
Posts: 1,179

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.

Posted 12 months ago #
riytav

Member
Joined: May '12
Posts: 2

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

Posted 7 months ago #
Softland

Key Master
Joined: May '08
Posts: 1,179

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.

Posted 7 months ago #

Reply

You must log in to post.