'%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 Excel to PDF Missing the Last Two Pages
Question details
The last two pages of an Excel workbook containing more than 25 pages are missing from the output file after converting it to a PDF.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Exporting a large, multi-page spreadsheet workbook into a PDF document.
- Observed behavior
- The resulting PDF document is incomplete, consistently omitting the final two pages of the original spreadsheet data.
Before making changes to your workbook settings, use the Print Preview feature to verify if the missing pages are also excluded from the standard print layout. Ensure no active data filters are accidentally hiding the bottom rows of your spreadsheet.
Verify and Adjust the Print Area and Page Breaks
Misconfigured print areas or restrictive page breaks are the most common reasons Excel excludes the final sections of a spreadsheet during a PDF export.
Excel uses your print settings to determine what gets converted into a PDF. If a specific print area was previously set, any data added outside of that area will be ignored when saving as a PDF.
Navigate to the 'View' tab on the top ribbon and select 'Page Break Preview'. Check if the last two pages of your data fall outside the solid blue boundary lines.
Go to the 'Page Layout' tab, click on 'Print Area', and select 'Clear Print Area' to remove any restrictive boundaries that might be cutting off your data.
Highlight all the cells you want to include in the final PDF, click 'Print Area' again, and choose 'Set Print Area'.
Reset Page Scaling Settings
If your spreadsheet scaling is strictly set to fit a specific number of pages, Excel might truncate the document to force it into that constraint.
Transfer Data to a New Workbook
If the issue only affects one specific workbook, the file's underlying formatting or print cache might be corrupted. Moving the data to a fresh file often resolves persistent export glitches.
Export Spreadsheets to Complete PDFs with WPS Office
Avoid truncated documents and missing pages by using WPS Office. Its robust spreadsheet software provides a built-in PDF converter that accurately renders large workbooks, preserving your layout exactly as intended without skipping data.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your .xlsx workbook directly.
- 2. Access the PDF Exporter: Click on the 'Menu' button in the top left corner and select 'Export to PDF'.
- 3. Adjust Export Settings: In the dialog box, select 'Entire Workbook' or specify the exact sheets, ensuring the export range covers all the pages you need.
- 4. Save the PDF: Click 'Export' to generate a complete, perfectly formatted PDF file without missing any end pages.
Frequently Asked Questions
Why are some columns cut off when converting Excel to PDF?
Columns get cut off when the data width exceeds the specified page size or print area. You can fix this by going to Page Layout > Scale to Fit and setting the Width to '1 page', which will automatically scale your columns to fit onto a single page width in the PDF.
Does Excel have a maximum page limit for PDF conversion?
No, there is no strict page limit for exporting an Excel file to PDF. However, extremely large files might encounter system memory limits or require properly configured print areas to ensure all pages are processed and rendered correctly.
How can I preview exactly what will be included in my PDF?
You can use the Print Preview feature by going to File > Print, or switch to the Page Break Preview mode via the View tab. The layout and pages displayed in these preview modes represent exactly what will be exported into your final PDF document.
