Convert select excel sheets to PDF
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.