Skip to main content
jennifero24685636
Participant
October 16, 2018
Question

Convert select excel sheets to PDF

  • October 16, 2018
  • 1 reply
  • 1229 views

I need to convert many excel workbooks to PDF.  I only want the first 8 sheets of each workbook. I went to FILE > CREATE> CREATE MULTIPLE and then added my folder containing the excel workbooks, clicked OK and OK.  My issue is that I can only get Acrobat to convert the first sheet of each workbook to PDF or all the sheets to PDF.  I only want the first 8 sheets in each excel workbook to convert.  I tried going to EDIT > PREFERENCE > MICROSOFT OFFICE EXCEL > EDIT SETTINGS > EDIT and then selected PAGES FROM and entered 1 to 8; however, this made no difference.  It still only saves the first sheet in each workbook.  I also tried checking CONVERT ENTIRE EXCEL WORKBOOK but then under EDIT still specifying 1 to 8, but that just ends up converting the entire excel workbook, not just the first 8 sheets.  I should mention that I can save a individual workbook as a PDF from excel just fine by selecting FILE > SAVE AS > PDF > OPTIONS and then selecting Page 1 – 8 and checking “Entire Workbook” under “Publish What.”  This will just convert the first 8 sheets, which is exactly what I want, but I would have to do that manually for each workbook I want to convert and I have a lot of workbooks so I’m hoping to make this work through Adobe Acrobat DC using the CREATE MULTIPLE option. 

This topic has been closed for replies.

1 reply

Participating Frequently
October 19, 2018

Support Staff will answer this more comprehensive, yet this feature changed years ago, so now you can't do the conversion for several sheets simultaneously. But you still can create each sheet as separate pdf and then merge them