PDF Converted From Excel Looks Wrong — Tables, Columns, and Cut-Off Fixes
Excel spreadsheets converted to PDF often have cut-off columns, wrong page breaks, and missing rows. Here's how to control the conversion and get a clean result.
Converting an Excel spreadsheet to PDF and getting a jumbled mess of cut-off columns, missing rows, and bizarre page breaks is extremely common. Excel is a flow-based application where the "page" is a construct — it was designed for infinite scrolling, not fixed-page output. Getting a clean PDF requires configuring Excel's print layout settings before conversion, not fixing the PDF afterward.
Why Excel PDFs Look Wrong
Excel converts to PDF by printing to a virtual page. If your spreadsheet is wider than the page (columns extending past the right margin), those columns get cut off. If the spreadsheet has no print area defined, Excel guesses where pages break — often splitting tables mid-row. Excel's default is A4 or Letter portrait orientation, which fits roughly 8-10 columns at normal font size. A spreadsheet with 20 columns will lose the right half unless you adjust the print settings.
Fix 1: Set the Print Area
Select exactly the cells you want in the PDF, then go to Page Layout → Print Area → Set Print Area. Excel will only export the selected range. This prevents blank columns, empty rows, and helper data from appearing in the PDF. For multiple disconnected ranges, you can set multiple print areas separated by commas — each appears on a separate page in the PDF.
Fix 2: Fit to Page Width
Go to Page Layout → Scale to Fit. Set Width to "1 page" and leave Height as "Automatic." This forces all columns to fit on a single page width regardless of count, shrinking the font size if necessary. For wide spreadsheets, also change Orientation to Landscape (Page Layout → Orientation → Landscape). The combination of landscape + "fit to width" handles most column cut-off problems. Alternatively, set the scale percentage manually: try 70-80% for moderately wide spreadsheets.
Fix 3: Control Page Breaks
Go to View → Page Break Preview to see exactly where Excel will split pages. Blue dashed lines are automatic page breaks; blue solid lines are manual page breaks. Drag solid lines to adjust them. To insert a manual page break before a specific row: select that row, then go to Page Layout → Breaks → Insert Page Break. This ensures your table breaks cleanly between logical sections rather than mid-row in the middle of a data group.
Fix 4: Repeat Row/Column Headers on Every Page
For multi-page spreadsheets, column headers should repeat on every page so each page is readable without reference to page 1. Go to Page Layout → Print Titles. In the "Rows to repeat at top" field, select your header row (e.g., $1:$1). For column labels: "Columns to repeat at left" (e.g., $A:$A). These repeat automatically on every page in the PDF output — essential for tables spanning multiple pages.
Fix 5: Export Correctly From Excel
Never use "Print → Save as PDF" for spreadsheets if you can avoid it — use File → Export → Create PDF/XPS instead. The Export function uses Excel's PDF library directly, which respects all Page Layout settings. The Print route sometimes ignores scale settings. In the Export dialog, choose "Standard (publishing online and printing)" for full quality. Check the preview before saving to confirm the layout matches your intent.
Try Compress PDF Now — Free
Browser-based, private, and instant. No account or software required.
Open Compress PDF