How to convert Excel to PDF the right way (no cut-off columns)

Why the layout goes wrong

Excel spreadsheets don't have a natural page size. A worksheet can be 200 columns wide by 10,000 rows tall — a shape no printed page can handle. When you export to PDF, Excel has to decide how to cut that landscape up. By default it cuts columns wherever they don't fit on the current page, which is why wide tables end up scattered across multiple orphan pages.

Three settings control everything:

1. Print area — which cells go into the PDF at all.
2. Fit to page — whether to scale down to make things fit.
3. Orientation and margins — how much room you actually have.

Get these right and the PDF looks the way you meant it to. Get them wrong and no online converter can save you.

The correct workflow (in Excel or Google Sheets)

Before exporting:

1. Select your data, then Page Layout → Print Area → Set Print Area. This tells Excel "only these cells go into the PDF." Otherwise it might include random blank cells you forgot about, sometimes stretching the print to 30 pages.
2. Page Layout → Orientation → Landscape if your data is wider than it is tall. This alone fixes most "columns wrapping to next page" problems.
3. Page Layout → Scale to Fit → Width: 1 page. This forces Excel to shrink the table until it fits horizontally. Leave "Height" as automatic — it's OK for tall data to span multiple pages, but not for columns to be cut off.
4. File → Export → PDF (Excel) or File → Download → PDF (Sheets).

Do those four things and 90% of Excel-to-PDF disasters go away.

Converting a .xlsx you didn't create

If you receive an Excel file and just need it as PDF, you have two options:

Option 1: open in Excel/Sheets first, apply the settings above, then export. More work but you get to see the preview.

Option 2: use an online converter. Faster but you can't control the layout — you're at the mercy of the defaults. Most online converters default to portrait with no fit-to-width, which is why "convert Excel to PDF online" so often produces bad PDFs.

Alternative: don't use PDF at all

Sometimes a PDF is the wrong output format. Two cases:

• The recipient will re-analyze the data. Ship them the .xlsx directly, or convert to CSV with Excel to CSV. CSV opens in every tool, has no layout to break, and is a fraction of the file size.
• You need to combine multiple spreadsheets. CSV to Excel reverse — you can also merge multiple CSVs into one Excel file, easier than reconciling multiple PDFs.

Ship PDF when the recipient needs to read but not edit — a report, an invoice, a printable summary.

Common failure modes and fixes

• Empty pages at the end. You have data far outside your visible area (a stray value in row 5000). Fix: set the print area explicitly.
• Text cut off inside cells. Not a PDF problem — the column was too narrow in Excel. Widen columns before exporting, or use Format → AutoFit Column Width.
• Numbers formatted differently in the PDF. Currency and percentage formatting doesn't always survive some online converters. Verify in the preview before sending.
• Charts render at low quality. Some converters rasterize charts at screen DPI. If print quality matters, export from Excel directly.

Follow-up steps

• If the resulting PDF is enormous because of embedded chart images, Compress PDF usually cuts it 50–70% with no visible loss.
• If you exported multiple sheets to separate PDFs, Merge PDF combines them into one document.

The privacy piece

Business spreadsheets often contain revenue numbers, customer lists, staff details, financial forecasts — the kind of data that should not sit on a stranger's server for an hour, let alone a month. If you go the online-converter route, use a browser-based tool where the file stays on your machine. Server-based converters, even the reputable ones, always retain the file for some window.