Fix Excel Page Setup Shows A4 but PDF Uses Letter Size
Question details
The user needs to prevent Excel from automatically changing an A4-sized worksheet into Letter size when generating a PDF.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Exporting or printing a precisely formatted A4 worksheet to a PDF document.
- Observed behavior
- The resulting PDF uses Letter size instead of the defined A4 size, which causes unexpected page breaks and misaligned content.
Save your current workbook to ensure no data is lost before modifying the global application settings in Excel.
Disable Automatic Scaling for A4 and Letter Paper Sizes
Turning off the automatic paper size scaling feature in Excel Options prevents the application from forcing A4 sheets into Letter dimensions during PDF export.
Excel includes a default setting that automatically scales documents to fit either A4 or Letter (8.5 x 11 inch) paper sizes based on regional printer defaults. While helpful for general office printing, this setting often overrides specific page setups when creating PDFs, resulting in unexpected page boundaries.
Launch Microsoft Excel. Click on the 'File' tab in the top-left corner of the ribbon, and select 'Options' located at the bottom of the left-hand menu.
In the Excel Options dialog box that appears, click on the 'Advanced' tab in the left-hand navigation pane.
Scroll down through the advanced options until you find the 'General' section. Clear the checkbox next to 'Scale content for A4 or 8.5 x 11 inch paper sizes'.
Click 'OK' to save your new settings. Return to your worksheet and export the workbook to PDF again to verify that the A4 dimensions are correctly maintained.
Export Spreadsheets to Accurate A4 PDFs with WPS Office
Avoid frustrating, hidden scaling overrides by using WPS Spreadsheet. It strictly respects your page layout settings, ensuring that your A4 worksheets are exported to PDF flawlessly. Plus, it is fully compatible with your existing Microsoft Excel files.
- 1. Open File in WPS Spreadsheet: Download and launch WPS Office, then open your existing Excel workbook.
- 2. Verify Page Setup: Navigate to the 'Page Layout' tab, click on 'Size', and confirm that 'A4' is explicitly selected.
- 3. Export Directly to PDF: Go to the 'Menu', select 'Export to PDF', and click 'Export' to generate a perfectly proportioned A4 document.
Frequently Asked Questions
Why does my Excel file always print as Letter size when set to A4?
This happens because Excel's advanced settings are configured by default to automatically scale content between A4 and Letter (8.5 x 11 inches) depending on localized printer settings. Disabling 'Scale content for A4 or 8.5 x 11 inch paper sizes' in File > Options > Advanced will resolve this automatic override.
Will disabling A4/Letter scaling affect my other Excel workbooks?
Yes, this is an application-level setting in Excel. Once disabled, Excel will strictly respect the specific page size defined in the Page Setup for all your workbooks moving forward, which is generally preferred for precise printing and accurate PDF exports.
How do I verify my exported PDF is actually A4 size?
Open the exported PDF in a dedicated PDF reader (such as WPS PDF or Adobe Acrobat), press Ctrl+D to open the Document Properties, and look at the Page Size under the Description tab. An A4 document should display dimensions of approximately 8.27 x 11.69 inches (or 210 x 297 mm).
