PDFFlare
8 min read

How to Convert Excel to PDF Without Cutting Off Columns

You finish a quarterly report in Excel, hit File → Save As → PDF, email it to your client, and ten minutes later you get the reply everyone dreads: “The right side of the page is cut off — can you resend?” You open the PDF and sure enough, the last three columns vanished off the edge. Or worse, they spilled onto a phantom page 2 with nothing else on it. This is the single most common pain point people hit when they try to convert Excel to PDF, and most online converters do nothing to help.

In this guide you'll learn how to convert Excel to PDF without cutting off columns using PDFFlare's Excel to PDF tool. The fix is two clicks: orientation and fit mode. Set them once and your XLSX, XLS, or ODS file exports cleanly the first time, every column visible, no spillover pages. We'll also cover sheet selection (so private “Internal” tabs don't leak into client deliverables), gridlines, and a few common gotchas that catch even experienced spreadsheet users.

Why Convert Excel to PDF in the First Place?

Sharing the .xlsx file directly seems easier — but PDF wins for almost every external-facing use case:

  • Locked formatting. Column widths, fonts, and page breaks all stay where you put them. Open the same .xlsx in a different version of Excel or in Numbers and the layout often shifts.
  • Read-only by default.Recipients can't accidentally (or deliberately) edit your numbers. The exported figures match what you sent.
  • Universal compatibility. Every device on earth can open a PDF. Excel files require Excel, LibreOffice, Numbers, or Google Sheets — all with subtly different rendering.
  • Smaller file size. A PDF of a 12-tab workbook is usually smaller than the workbook itself once charts and formulas are flattened to rendered output.
  • Required by clients.Most procurement, legal, and finance workflows simply won't accept .xlsx. PDF is the de facto archival format.

The “Cut-Off Columns” Problem, Explained

Excel and Calc both default to a portrait page in the printer's paper size (A4 or US Letter), with no scaling. That means a spreadsheet with 25 columns of financial data will render something like seven or eight columns on page 1, the next eight on page 2, and the last few on page 3. The sequence repeats for every horizontal print band. From a reader's perspective, half their data is “missing” — it's actually there, just buried in the next print band.

Worse, if your sheet is just barely wider than the page width, you'll get one column orphaned onto a tiny page 2. Hitting print produces a stack of mostly-blank pages.

The fix is to tell the renderer: “take whatever width my spreadsheet is, and squeeze it to fit one page wide.” In Excel desktop this lives in Page Layout → Width → 1 page. Most online converters never expose this control. PDFFlare does.

How to Convert Excel to PDF (The Right Way)

Step-by-step using PDFFlare. The whole flow takes under a minute, no signup, no software install:

  1. Open the tool. Go to pdfflare.com/tools/pdf/excel-to-pdf. No account needed.
  2. Drop your file. Drag your .xlsx, .xls, or .ods into the upload area, or click to browse. Files up to 50 MB work on the free tier.
  3. Pick the sheets you want.A panel appears listing every sheet in your workbook. Hidden sheets show up grayed out — they're excluded by default so private tabs don't leak into the export. Click “Deselect all” then tick just the sheets you need.
  4. Set orientation and fit.The defaults are already optimized: orientation is auto, fit mode is “Fit all columns to one page wide.” For wide reports, change orientation to Landscape — it gives the renderer more horizontal room before it has to scale text down.
  5. Convert and download.Click “Convert to PDF” and the server runs LibreOffice Calc with your settings. The PDF appears in seconds.

Four More Cutoff-Column Tricks

Even with fit-to-width on, super-wide sheets sometimes need a little help. Here are four preparatory tricks worth knowing:

  1. Set Print Area in Excel before exporting. Highlight only the columns you actually want to print, then Page Layout → Print Area → Set Print Area. The PDF will only include those columns instead of everything across the sheet.
  2. Reduce font size on totals or summary rows.If one row has long-text labels (“Quarterly Operating Expenses, Adjusted”) it can balloon a column's minimum width. Shrinking that row's font from 11 pt to 9 pt often saves 30% page width.
  3. Use a wider page size. If A4 / Letter still crams text, switch to A3 or Tabloidin PDFFlare's Page Setup card. Big wall-printable PDFs are sometimes the right answer for dashboards and pivot summaries.
  4. Try Custom Zoom for surgical control. If fit-to-width shrinks text more aggressively than you'd like (say, 60% to fit on one page), try Custom Zoom at 80% or 85% instead. The PDF will be slightly wider than one page, but text stays readable. After exporting, run the PDF through Compress PDF if the file size grows past your email limit — a 5 MB Excel export usually compresses to under 2 MB without visible loss.

Common Mistakes When Saving Excel as PDF

  • Forgetting to set the print area.Excel cheerfully includes that “scratch” column you put 30 cells over to the right. Set the print area or the PDF will include 50 blank columns followed by your scratch data.
  • Hidden tabs leaking into the export.Exporting the whole workbook can include hidden “Internal” sheets you forgot were there. PDFFlare excludes hidden sheets by default; if your previous tool didn't, double-check the PDF before sending.
  • Wrong locale formatting.European-format numbers (1.234,56) sometimes flip to US format (1,234.56) or vice versa during conversion. Lock it down by formatting cells explicitly in Excel before exporting — don't rely on locale defaults.
  • Charts rendering as blanks. Charts built from external pivot data sometimes lose their backing source on export. Open the chart in Excel, click Refresh All, then save the workbook before converting.
  • Currency symbols missing.Some legacy XLS files use a font that the converter doesn't have. Switch those cells to a system font like Arial or Calibri before export, or accept Liberation Sans as the substitute.

Use Cases We See Every Day

A few scenarios where dialed-in Excel-to-PDF settings make a tangible difference:

  • Quarterly P&L for clients. Landscape + fit-to-width + Letter page size + center horizontally. The financial report fits cleanly on one page per sheet. Pair it with Sign PDF to add your signature before sending — clients see a single polished, signed deliverable instead of an unsigned spreadsheet.
  • Employee shift schedules. Landscape + fit-to-page (entire sheet on one page). Even a 4-week schedule fits when scaled to one page.
  • Budget vs. actual dashboards. A3 + landscape + print gridlines on. Looks like a board-room handout instead of a screenshot.
  • Invoices and quotes. Portrait + Letter + fit-to-width. Standard letter format, everything legible.
  • Inventory exports.Sheet picker — pick just the “Active SKUs” tab and skip the “Discontinued” and “Internal” tabs.

Privacy and File Handling

PDFFlare uploads your spreadsheet over HTTPS to an isolated server container, runs LibreOffice Calc to render the PDF, and streams the result back. Files are automatically deleted within minutes after the conversion finishes. No analytics on file contents, no storage, no third-party sharing. The conversion runs entirely on PDFFlare infrastructure — no third-party APIs are called with your data.

If your spreadsheet contains regulated data (PII, medical, legal privileged), make sure your organization's policy permits uploading to a third-party tool. PDFFlare is suitable for most business workflows but defer to your security team for high-sensitivity content.

Related Tools

Once you have your PDF, a few PDFFlare tools that pair well with Excel-to-PDF workflows:

  • Compress PDF — shrink the output for email if it's pushing past the 10 MB inbox limit.
  • Merge PDF — combine your sheet exports with a Word cover page or other attachments into a single deliverable.
  • Word to PDF — same engine, same fidelity, for the cover letter or memo that goes alongside your spreadsheet PDF.
  • PDF to Word — when a client sends back a PDF and you need to edit it.
  • Sign PDF — add a signature to the converted PDF before sending.

Wrapping Up

The reason most online Excel-to-PDF converters produce ugly, column-cut-off output is that they don't expose the two settings that actually matter: orientation and fit-to-width. PDFFlare does, and they're on by default. For a wide report, flip orientation to landscape, double-check the sheet picker, and click convert. Your client gets a clean PDF that reads like a professional document instead of a botched print job.

Convert your first spreadsheet now — PDFFlare's Excel to PDF tool is free, browser-based, and supports XLSX, XLS, and ODS up to 50 MB. No signup. No watermark. No surprises.