Excel to PDF: How to Stop Columns Being Cut Off

The spreadsheet is fine on screen. The PDF has the first six columns on page one, the remaining three stranded on page four, and a header row that appears exactly once. Nothing was corrupted: the export applied print settings you were probably never asked about.

A spreadsheet has no pages until you export it

A word processor document knows its own page size, so converting it to PDF is close to a copy. A sheet is an open grid with no inherent edge. Exporting one forces a decision that was never made while you were working: where to cut it into pages, and whether to shrink it so the cuts fall somewhere tolerable.

That decision lives in the page setup, and the defaults are portrait, no scaling and a print area covering everything the application believes is in use. For a wide table those three defaults produce exactly the failure above.

Set it up before you export

1. 1Set the print area explicitly to the range you want. Without it, one forgotten value in a distant cell stretches the used range and brings a field of empty pages with it.
2. 2Switch to landscape if the table is wider than it is tall. This alone resolves a great many cut-off columns and costs nothing in readability.
3. 3Scale to one page wide by as many pages tall as it takes. Do not scale to a single page. Fitting one page wide constrains only the horizontal axis; fitting one page entirely squeezes both, and that is what produces text too small to read.
4. 4Turn on the setting that repeats the header row on every page, so pages two onward are not anonymous columns of numbers.
5. 5Open the page-break preview and look at where the breaks actually land. Moving a break by one column is usually better than shrinking the whole sheet.
6. 6Widen any column showing truncated text or a row of hash marks. The PDF records what is displayed, not what is stored, so a value hidden by a narrow column is simply absent from the export.

What still catches people out

• Hidden columns and filtered rows export as they appear, so anything hidden is gone. That is sometimes exactly what you want and sometimes a missing quarter.
• Conditional formatting that relies on colour becomes meaningless if the document is printed in greyscale. If the colour carries the meaning, add a symbol or a label as well.
• Notes and comments are usually not printed unless you ask for them, so review threads vanish silently.
• Charts and images anchored to cells can move or clip when the scaling changes. Check them after adjusting page setup rather than before.
• Gridlines and row or column headings are off by default. For a table people will read line by line, gridlines are often worth turning on.
• Multiple sheets are not all included by default. Exporting the workbook rather than the active sheet is a separate choice.

Check the exported file, not the preview

1. 1Open the PDF itself. The print preview and the export do not always agree, particularly where fonts differ.
2. 2Go to the last page first. Truncation shows up at the end, and so do stray pages from an oversized print area.
3. 3Confirm every page after the first carries the header row.
4. 4Search the PDF for a value from the far-right column. If the search finds nothing, that column did not make it.
5. 5Look at it at the size it will actually be read, on a phone if that is where it is going. A table that needs zooming on every page has not really survived the export.

What Formynex can and cannot do here

Formynex does not convert spreadsheets to PDF. There is a page at /tools/excel-to-pdf describing the tool, but nothing is connected behind it and it is kept out of search results until something is. That is not only a gap in what is built: the export genuinely belongs in the spreadsheet application, because the print area, the scaling and the repeated header row are its settings, and an outside converter would be guessing at all three. Excel, Google Sheets and LibreOffice Calc each export to PDF directly, and each exposes the page setup described above.

Once you have the PDF, the work that follows is ordinary PDF work, and these Formynex tools do run in your browser: Compress PDF if the file has to clear an attachment limit, Merge PDF to bind the tables into a report, Add Page Numbers for a document that will be referred to in a meeting, Rotate PDF when landscape tables end up sideways next to portrait pages, and Extract Pages to send someone a single table rather than the whole workbook.

If the exported file is too large for email, compressing a PDF for an email size limit covers what compression can and cannot remove. Documents exported from a word processor have their own version of these problems, described in converting Word to PDF without losing formatting.