How do I create a PDF document from an Excel document containing multiple worksheets?
One note: If the user is attempting to print multiple worksheets at once from Excel, each worksheet will print as a separate document. This is a “by-design” behavior of Excel. With PDF Complete Office Edition and PDF Complete Corporate Edition, you may create a single document by APPENDING to the previously created PDF document. To append the 2nd, 3rd, etc worksheet to the previous worksheets, select an existing PDF document in the file browser window. Uncheck the box “View pdf After Creation”. Select SAVE to overwrite the document, APPEND to add to the end of the existing document, or INSERT to place the new document at the beginning of the existing document. To accurately print a specific area of a worksheet, use the FILE, PRINT method to create a PDF document. Select your print range. Utilize “Print Preview” in order to see the printed portions of the document. Select the PDF COMPLETE printer to create a PDF document. Alternatively, use FILE, PAGE SETUP to set the scaling factor for
