How to Change PDF Page Size When Exporting Excel with Acrobat
Question details
The user needs to resolve an issue where exporting an Excel worksheet to PDF using Adobe Acrobat results in unexpected page dimensions, rather than the intended standard paper size like Letter.
- Product
- Microsoft Excel and Adobe Acrobat
- Device & OS
- not provided
- Scenario
- Exporting a worksheet from Microsoft Excel to PDF using the Save As Adobe PDF feature or Acrobat printer.
- Observed behavior
- The resulting PDF has incorrect or inflated page dimensions due to Excel's percentage scaling factor conflicting with the PDF page size settings.
Ensure that Adobe Acrobat is installed on your computer so that the 'Adobe PDF' printer is available in your Excel print options, and verify the intended paper size (such as Letter or A4) in your worksheet's Page Layout settings.
Print Directly to Adobe PDF and Configure Printer Properties
Bypassing the 'Save As Adobe PDF' plugin and using the Print menu allows you to strictly define the Adobe PDF printer properties, effectively ignoring problematic scaling factors.
Excel's internal scaling factor (such as scaling a worksheet to 85%) can sometimes cause the Adobe Acrobat add-in to output a PDF with physically larger dimensions relative to your intended letter size. By printing directly to the Adobe PDF printer and turning off percentage scaling, you force the output to adhere to standard page dimensions.
In your open Excel workbook, click on 'File' in the top-left corner and select 'Print' from the left-hand menu.
Under the Printer dropdown menu, select 'Adobe PDF' as your active printer.
Click on 'Printer Properties' directly below the printer name. Go to the 'Adobe PDF Settings' tab and ensure the 'Adobe PDF Page Size' is set to your required dimension (e.g., Letter).
Return to the Print settings menu in Excel. Under the Settings section, click on the scaling options at the bottom (usually 'No Scaling' or 'Custom Scaling') and choose 'Fit Sheet on One Page' or 'Fit All Columns on One Page' instead of using a custom percentage scale.
Click the large 'Print' button to generate and save your newly dimensioned PDF file.
Export Spreadsheets to Perfectly Sized PDFs with WPS Office
If third-party plugins and printer settings are causing unexpected scaling issues, try WPS Office. WPS Spreadsheet features a flawless built-in PDF exporter that retains your exact page layouts without requiring Adobe Acrobat.
- 1. Open Your Spreadsheet: Launch WPS Office and open your existing Excel workbook (.xlsx or .xls).
- 2. Navigate to the Tools Tab: On the top ribbon, click on the 'Tools' tab to access advanced document options.
- 3. Select Export to PDF: Click the 'Export to PDF' button. A dialogue box will appear allowing you to manage export settings.
- 4. Confirm Page Settings: Ensure your export range and layout preferences match what you see on the screen without any distorted scaling.
- 5. Export and Save: Click 'Export to PDF' at the bottom of the dialogue box to instantly generate a perfectly sized PDF.
Frequently Asked Questions
Why is my exported PDF page larger than Letter size?
This usually happens when you use a custom percentage scaling factor (e.g., 85%) in Excel's Page Setup. Adobe Acrobat's PDF creator interprets this scaling by expanding the physical dimensions of the PDF page rather than shrinking the content. Changing the scaling to 'Fit to 1 page' usually resolves this.
Can I permanently set the default PDF page size in Excel?
You cannot set a default PDF size exclusively within Excel, but you can change the default paper size in your computer's 'Printers & Scanners' settings. Find the 'Adobe PDF' printer, go to Printer Preferences, and set your desired default page size there.
What is the difference between 'Save As Adobe PDF' and printing to PDF?
'Save As Adobe PDF' uses an Acrobat add-in which converts active links, bookmarks, and structural data, but it sometimes mishandles Excel's unique page scaling. Printing to the 'Adobe PDF' virtual printer strips out interactive elements but strictly adheres to physical print layout rules, which often fixes dimension issues.
