'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Extra Excel Page Breaks When Printing to PDF
Question details
The user experiences unexpected page breaks or missing pages when exporting an Excel workbook to PDF with manual page breaks and the Fit All Columns on One Page setting enabled.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Printing or exporting a spreadsheet to PDF using Microsoft Print to PDF or third-party PDF printers.
- Observed behavior
- Excel adds extra page breaks or omits pages instead of honoring the manual page breaks and column fitting settings.
Save a backup copy of your workbook before adjusting print settings. Check if the issue occurs with a single specific sheet or across all newly created Excel files.
Update Microsoft Excel to the Latest Version
Resolves known bugs related to the auto-fit scaling setting interacting with manual page breaks.
Microsoft frequently releases updates to address layout and printing bugs. Updating your Microsoft 365 Apps ensures you have the latest patches for the PDF rendering engine.
Open Microsoft Excel, click on the File tab in the top left corner, and select Account from the bottom left menu.
Under the Product Information section, click the Update Options button, then select Update Now from the drop-down list.
Wait for the updates to download and install. Once complete, restart Excel, open your workbook, and attempt to print to PDF again to see if the page breaks are fixed.
Test Printing from Another Computer
Helps determine if the PDF printing issue is isolated to a specific local Excel installation or printer driver.
Clear and Reset Print Area and Page Breaks
Removing corrupted manual page breaks can sometimes resolve conflicts with the auto-fit scaling settings.
Print to PDF Flawlessly with WPS Office
If Microsoft Excel continues to add extra page breaks or struggle with your print settings, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with robust and reliable PDF export capabilities, completely free of charge.
- 1. Download and Install: Download WPS Office for free from the official website and install it on your computer.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing Microsoft Excel workbook.
- 3. Export to PDF: Go to the Menu, select Export to PDF, adjust your page layout settings, and generate a perfectly formatted document without extra page breaks.
Frequently Asked Questions
Why does 'Fit All Columns on One Page' ignore my manual page breaks?
In some versions of Excel, combining auto-scaling settings (like Fit All Columns) with manual page breaks causes a calculation conflict, resulting in ignored breaks or extra blank pages when rendering the PDF.
Does changing the PDF printer fix the extra page breaks?
Usually not. If the bug is within the Excel version's layout engine, both Microsoft Print to PDF and third-party PDF printers like Adobe PDF will output the same extra page breaks.
How can I preview the page breaks before printing to PDF?
Click on the View tab and select Page Break Preview. This allows you to visually inspect and drag the blue lines to adjust exactly where the pages will break before exporting the document.
What should I do if updating Excel doesn't solve the printing issue?
If the latest version still produces extra pages, try removing all manual page breaks and manually using the Scale to Fit percentage adjustments in the Page Layout tab instead of the Fit All Columns option.
