How to Prevent Excel Data from Being Cut Off When Saving as PDF
Question details
Users experience data loss along the bottom and right edges when printing or exporting an Excel worksheet to a PDF file.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Exporting or printing a spreadsheet to PDF format.
- Observed behavior
- Spreadsheet data is missing or truncated at the margins in the resulting PDF document.
Before adjusting your spreadsheet, ensure that your default printer settings are correct, as Excel relies on default printer drivers to render page layouts for PDFs.
Adjust Scaling to Fit All Columns on One Page
Use Excel's built-in scaling feature to force all data columns to fit within the width of a single PDF page.
The most common reason for horizontal truncation is that the columns exceed the standard page width. Scaling shrinks the printed output down automatically so that it fits onto the pages you specify.
Navigate to the 'Page Layout' tab on the top ribbon of your Excel workbook.
Find the 'Scale to Fit' group within the ribbon.
Change the 'Width' dropdown from 'Automatic' to '1 page'. This guarantees no columns are pushed to a second page.
Leave the 'Height' as 'Automatic' if you want the data to span multiple pages vertically, or set it to '1 page' to fit the entire sheet onto a single page.
Set the Correct Print Area and Adjust Page Breaks
Define exactly which cells should be included in the PDF and manually adjust page breaks to prevent data splitting.
Change Paper Size and Orientation
Switching from Portrait to Landscape orientation provides more horizontal space, which is ideal for spreadsheets with many columns.
Easily Export Spreadsheets to PDF with WPS Office
WPS Spreadsheet provides an intuitive export-to-PDF tool with easy layout adjustments, ensuring your data never gets cut off.
- 1. Open Spreadsheet: Open your Excel or WPS spreadsheet file in WPS Office.
- 2. Select Export to PDF: Click on 'Menu' in the top-left corner and select 'Export to PDF'.
- 3. Adjust Layout Settings: In the dialog box, click on the export settings to select 'Fit Sheet on One Page' or adjust the margins visually.
- 4. Export File: Click the 'Export' button to generate a perfectly formatted PDF with all your data intact.
Frequently Asked Questions
Why does Excel change my layout when I save as PDF?
Excel relies on your default printer's metrics to determine page sizes, margins, and rendering. If the default printer driver has limited margin capabilities, it may force Excel to truncate the layout during the PDF conversion process.
Can I save just a specific chart to PDF without cutting it off?
Yes. Click to select the chart directly, then go to File > Save As and select PDF. Excel will automatically export only the selected chart, scaling it perfectly to fill the page.
How do I hide blank pages from being included in the exported PDF?
Before exporting, you need to set a specific Print Area that only covers your data. Select the range you want to keep, then go to Page Layout > Print Area > Set Print Area. This ensures that empty rows and columns outside your data are completely ignored.
