fitforpdf

Why Excel cuts off columns when exporting to PDF (And how to fix it)

Exporting a wide Excel sheet to PDF often results in cut-off columns. This guide explains why it happens and how to fix it, with and without external tools.

Why Excel PDF export breaks on wide sheets

Excel exports the configured print area using the selected page size and scaling. Columns can be excluded by the print area, continue onto later pages, or become small when the whole table is scaled down. Inspect the preview to identify which applies.

Manual workarounds

  • Check that the print area includes the columns you want
  • Compare scaling to one page wide with allowing several pages
  • Switch orientation to Landscape
  • Adjust column widths and margins while checking text size
  • Repeat identifier columns with Print Titles when using several pages

Limitations of manual fixes

Scaling can make text too small. Landscape adds width, but the result also depends on column widths and page size. If you split the table across pages, repeated identifiers help readers connect the data.

Structured export with fitforpdf

fitforpdf creates a new table layout with column sections and repeated key columns. Sections can span several pages. Upload a tabular CSV or XLSX with a clear header row; for XLSX, only the first worksheet is read. Review the preview before sharing.

Conceptual example

A source table with contact and deal fields
Name | Company | Email | Stage | Deal value
Check that the Excel print area includes every field you need.
Possible groups with repeated identifiers
Contact fields: Name | Company | Email
Deal fields:    Name | Company | Stage | Deal value
Actual grouping and pagination depend on the file and settings.

Conceptual diagram, not a measured result. Check the PDF produced from your own file.

Frequently asked questions

Why does Excel cut off columns in PDF exports?

Check the print area, hidden columns and page breaks. Columns outside the print area are excluded, while a wide print area can continue onto additional pages or shrink depending on scaling settings.

How do I stop Excel from cutting off columns when printing to PDF?

Check that the print area includes the intended columns. In Page Layout → Scale to Fit, setting Width to 1 page can fit them horizontally, but inspect the text size. You can also allow more pages or split the table into sections.

Why does my Excel PDF only show half the columns?

The print area may exclude columns, some columns may be hidden, or the remaining columns may be on later pages. Inspect Print Preview and adjust the print area before changing tools.

Can I fix cut-off columns without a tool?

Yes. Adjust the print area, scaling, orientation and margins, then inspect all pages in Print Preview. Allowing more pages can preserve text size.

Does fitforpdf preserve all columns?

fitforpdf distributes the selected table columns across sections and repeats key columns for context. For XLSX files, it reads the first worksheet only; hidden or excluded columns are not included. Check the preview against your source table.

Fix your Excel export now

Try a new layout for your table and inspect the preview. 3 free exports with a watermark.

Generate your first PDF, free