Error has occurred!
- KB185
- Aug 12, 2021 10:09 AM
Can I use Excel to print several sheets in a single PDF?
Answer:
Yes, conversion of Excel documents is available using our PDF-XChange Standard Office Add-in.
Solutions:
Click each of the headers below to expand the steps for that method.
Convert with Office Addin
1. Open the Excel Workbook.
2. On the PDF-XChange tab, click on the Edit Settings button.
3. Click Excel Options.
4. Click Entire Workbook or Sheets From a Range. With Sheets From a Range you will need to specify the range you want.
5. Click OK.
6. Click Convert to PDF.
7. Choose The file location and name to save to then click Save
Print via Standard Printer
1. Open the Excel Workbook.
2. Press CTRL+P to Print the File.
3. Change Printer to PDF-XChange Standard or PDF-XChange Lite.
3. Under Settings Choose Print Entire Workbook.
4. Specify Pages if you only want certain sheets to print.
5. Click Print.
7. Choose The file location and name to save to then click Save.
Possible Errors
In some cases Excel can get itself mixed up and try to print on an alternate page size, resulting in the output being split into a new document every few sheets. If you are experiencing this issue, and the options above did not help, please see this article: https://answers.microsoft.com/en-us/msoffice/forum/all/why-has-excel-started-creating-multiple-pdf-files/6e4c3846-2a7b-4697-b625-3686fdd7a917
More Like This
- KB#456: How Do I Customize toolbars in PDF-XChange Editor?
- KB#282: Why won't the "Email Document" feature work in conjunction with Microsoft Outlook?
- KB#338: What are the MSI installation switch options for the PDF-XChange family of products?
- KB#447: How do I determine what version I should install/how can I retrieve my serial key?
- KB#286: How do I manage licenses for PDF-XChange Products on a Windows Terminal Server?