Exporting Spreadsheets to PDF Without Cut-Off Columns

Finance exported Q3 actuals — 14 columns, portrait letter, "fit sheet on one page." PDF arrived: columns A through H visible, text 4pt, columns I–N extinct. The board meeting started in twenty minutes.

Spreadsheets aren't documents until export settings respect column count.

Root causes of cut-off exports

• Print area includes 200 empty columns
• Fit all columns on one page shrinks to illegible
• Portrait on 12-column table
• Margins + header/footer eating width
• Hidden rows/columns surprise
• Page break mid-merged cell

Excel export workflow

1. Clean the sheet

• Delete unused columns/rows outside data
• Freeze header row for multi-page (Print Titles → repeat row 1)
• Consistent number formats — Invoice Rounding for currency

2. Set print area

Select data block → Page Layout → Print Area → Set Print Area

3. Orientation and size

• Landscape for wide tables
• Legal or A3 if shop supports — ask before board packet
• Printable PDF Margins — narrow margins for internal reports only

4. Scaling intelligently

| Goal | Setting | | --- | --- | | Readable multi-page | 100% scale, landscape | | Fit width only | Width: 1 page, Height: automatic | | Fit entire on one page | Last resort — verify font size | | Split by section | Multiple print areas / sheets |

5. Export

File → Save As → PDF or Print → Microsoft Print to PDF

Verify page count preview before save.

Google Sheets

File → Print — landscape, scale, margins, gridlines. "Fit to width" vs "Fit to page" same traps as Excel.

Multi-table reports

Don't stack unrelated tables one sheet — page breaks orphan headers. Separate tabs exported via Merge PDF with cover sheet.

Charts and images

Charts export as vectors sometimes, raster others — test color — PDF Color Profiles.

Large images inflate size — Compress PDF after verify.

GST and tax columns

Multi-rate invoices — Sales Tax Multiple Rates, GST Inclusive vs Exclusive. Wide tables need landscape.

When PDF isn't right

• Interactive pivot → send Excel with password
• Live formulas → PDF is snapshot only
• Huge datasets → CSV + summary PDF page

Troubleshooting

Why are columns cut off when I export Excel to PDF? Usually wrong print area, scale-to-fit forcing tiny text, portrait orientation on wide tables, or margins too wide. Set print area to exact range, try landscape, and adjust scaling to fit width only or use legal paper size.

How do I fit a wide spreadsheet to one PDF page width? Page Layout → Width: 1 page, Height: automatic (or set both if must fit one page). Warning: too many columns on one page makes text unreadable — prefer multiple pages or split tables.

Should I export spreadsheet PDF in portrait or landscape? Landscape for tables wider than ~6–8 columns. Portrait suits narrow reports and tall data. Match orientation to data shape, not default habit.

Limitations

When not to use this approach

Conclusion

Print area + landscape + width-fit (not sheet-squash) for wide tables. Preview page count before the board meeting.

If text drops below 8pt, add pages — not smaller pixels. Columns I–N deserve visibility too.

Repeat header rows

Excel: Page Layout → Print Titles → Rows to repeat at top: $1:$1. Multi-page exports without repeating headers confuse readers — "what column is this?"

Page breaks manual control

Insert page break before major section headers — avoid orphaned summary row at page bottom. Print preview scroll entire document before sending to CFO.

Google Sheets limitations

Complex Excel charts may render differently in Sheets export — native Excel PDF export preferred for chart-heavy board packs.