Fix Excel PDFMaker Using the Wrong Paper Size
Question details
The user needs to know why Excel PDFMaker produces PDFs with an incorrect or unexpected paper size and how to resolve the discrepancy.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Converting an Excel workbook to a PDF using the Adobe PDFMaker add-in, resulting in incorrect page dimensions.
- Observed behavior
- PDFMaker outputs a PDF with an unexpected page size due to differing interpretations of Excel's page layout, print area, scaling, and printer settings compared to the standard Adobe PDF printer.
Before attempting to convert the file, ensure your computer's default printer is not forcing a specific paper size that overrides your Excel worksheet settings.
Adjust Excel Page Layout and Align Conversion Settings
Reconfigure your worksheet's page setup and ensure that the PDFMaker settings match the standard Adobe PDF printer properties.
PDFMaker can sometimes misinterpret Excel's complex print areas and scaling rules. Manually enforcing a specific paper size and checking the internal PDFMaker settings will ensure accurate PDF dimensions.
Open your workbook and go to the 'Page Layout' tab. Review the orientation, margins, and scaling options to ensure they fit your intended design.
Under the 'Page Layout' tab, click 'Size' and explicitly set the worksheet to 'A4' (or your target paper size) rather than leaving it on a default setting.
Click 'Print Area' to clear or reset it if necessary. Switch to 'Page Break Preview' under the 'View' tab to ensure your content is appropriately distributed across pages.
Open the Acrobat PDFMaker settings from the Acrobat ribbon tab. Verify that the conversion settings (like page size and scaling) do not conflict with the properties of the Adobe PDF virtual printer.
Save the Excel workbook to lock in the layout changes, then click 'Create PDF' using the PDFMaker add-in.
Convert Excel to PDF Accurately with WPS Office
Avoid third-party add-in conflicts entirely. WPS Spreadsheet includes a highly accurate, built-in 'Export to PDF' feature that perfectly preserves your paper size, scaling, and print areas without requiring external tools like PDFMaker.
- 1. Open your spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx or .xls file.
- 2. Set your Page Layout: Navigate to the 'Page Layout' tab to explicitly set your paper size (e.g., A4), margins, and print area.
- 3. Access the PDF export tool: Click on the 'Tools' tab and select the 'Export to PDF' button, or go to 'Menu' > 'Export to PDF'.
- 4. Configure export settings: In the export dialog box, verify your export range and ensure the layout options match your desired output.
- 5. Generate the PDF: Choose a save location and click 'Export'. The resulting PDF will perfectly match your specified paper size.
Frequently Asked Questions
Why does my Excel to PDF conversion cut off columns?
This happens when the scaling is set to 100% and the columns exceed the paper width. Adjust this by going to Page Layout and setting the scaling to 'Fit All Columns on One Page' before exporting.
What is the difference between Adobe PDF Printer and PDFMaker?
The Adobe PDF Printer is a virtual printer that captures standard print output from any application. PDFMaker is an Office add-in that captures structured data like bookmarks, links, and tags, but it may interpret complex Excel layout settings differently than standard printing.
How do I force Excel to save a PDF strictly in A4 size?
Go to the Page Layout tab, click 'Size,' and select A4. Make sure your default printer is set to a PDF printer to lock in the dimensions, and ensure your scaling settings aren't pushing content beyond the A4 margins.
Can WPS Office export to PDF without installing Acrobat?
Yes, WPS Office features a native Export to PDF function that directly and accurately converts spreadsheets into PDF documents, requiring no additional Adobe software or add-ins.
