I recently received the following inquiries from customers::
Some of my Excel files contain more than one worksheet. I would like to convert the second worksheet in an Excel file to the same PDF.
I have over 1000 Excel documents to convert to PDF as part of a regulatory filing. Is there a way to convert these all to PDF in batch?
I’ll tackle both of these needs in this article.
Converting Multiple Worksheets
Fortunately, Acrobat 8 and later can easily convert all of the worksheets in your Excel files to PDF:
When you use the PDF Maker in Acrobat 9, you have some additional options to select just the worksheets needed:
A) Choose options to convert all worksheets, the currently selected worksheet or a subset of the worksheets.
B) To choose some worksheets, but not others, select from the list on the left and use the Add or Remove buttons to move them to the list on the right.
C) Click the Convert to PDF button to complete the process
The result is a nicely bookmarked PDF that looks like this:
What about batch conversion?
If you want to convert many Excel documents in batch to PDF, there are a few additional tricks involved. Read on learn how in the rest of the article.