Excel to PDF: Why Columns Get Cut Off and How to Fix It Before Converting

A spreadsheet doesn't have pages — it's a continuous grid that scrolls in both directions. A PDF is the opposite: a fixed sequence of fixed-size pages. Converting one to the other means Excel (or the conversion engine standing in for it) has to decide where page breaks fall, both down the rows and across the columns. When a sheet is wider than the chosen page size, the columns that don't fit get pushed onto a second page, or in the worst case, cut off entirely depending on the print settings baked into the file.

Why this happens

Excel workbooks carry their own print settings — print area, page orientation, scaling — that were likely set (or never set) for viewing on screen, not for printing to a fixed page width. If those settings weren't configured with printing in mind, converting straight to PDF just carries the same problem into the output file: columns past the print area boundary land outside the visible page.

Fixing it before you convert

• Set the print area in Excel to cover exactly the range you want in the PDF.
• Use Page Layout > Scale to Fit and set Width to 1 page, so all columns are forced onto one page width.
• Switch to landscape orientation for wide tables — it roughly doubles the usable width before anything needs to shrink.
• Check File > Print Preview before converting; if it looks right there, it will convert correctly.

Converting once the sheet is ready

Our Excel to PDF tool respects the print settings already saved in the workbook, which is exactly why fixing them beforehand matters — the conversion isn't guessing at layout, it's following the page setup Excel already has. A sheet with a correctly configured print area and scale-to-fit will convert with every column intact; one without those settings will carry the same cutoff into the PDF that you'd see printing directly from Excel.