Excel to PDF Cuts Off Columns or Rows — How to Fix It
Excel spreadsheets converted to PDF with missing columns, truncated rows, or multiple pages where one was expected are a print area and page scaling problem. Here's how to fit it correctly.
An Excel spreadsheet converted to PDF with columns cut off on the right, rows cut off at the bottom, or content sprawling across many more pages than expected is a page scaling problem. Excel's default print settings do not automatically scale your spreadsheet to fit the page — they use the actual column widths and row heights to determine what fits, which rarely matches standard paper sizes.
Fix: Set Page Scaling Before Export
In Excel: Page Layout tab → Scale to Fit group. Set "Width" and "Height" dropdown. For most situations: set Width to "1 page" (fits all columns on one page width) and Height to "Automatic" (lets the height grow naturally over multiple pages if needed). Alternatively: Page Layout → Page Setup (dialog launcher) → Page tab → "Fit to: 1 page(s) wide by ___ tall." Preview with Ctrl+P to verify before exporting. For very wide spreadsheets, consider Landscape orientation (Page Layout → Orientation → Landscape).
Print Area: Only Export the Data Range
Excel often includes empty columns and rows in the export because it does not know where your data ends. Fix: select only the data range you want to export → Page Layout → Print Area → Set Print Area. Now only the selected range will be included in the PDF. This is especially important if your sheet has formulas or formatting outside the visible data range — those empty-looking cells still have print properties that expand the page count dramatically.
Column Widths: Adjust for Print Size
Even with scaling set, very wide column widths combined with many columns may make scaling reduce text to an unreadably small size. Consider: hiding columns that are not needed for the printed version (right-click column header → Hide), reducing column widths by selecting all columns and dragging the column separator, or splitting the report into multiple sheets — one for each logical group of columns — and exporting each separately.
Using Page Break Preview to Control Layout
View → Page Break Preview shows exactly where page breaks will fall in your current layout as blue dotted lines. You can drag these blue lines to manually set where each page breaks. The content adjusts to fit within the new break positions. This is the most precise way to control exactly what appears on each page of the PDF. Blue solid lines are manually set breaks; blue dashed lines are automatic. To remove all manual breaks: Page Layout → Breaks → Reset All Page Breaks.
Try Compress PDF Now — Free
Browser-based, private, and instant. No account or software required.
Open Compress PDF