You can handle this directly in your browser with our free pdf to word tool — nothing gets uploaded.
You have a spreadsheet that looks perfect on screen. You export it to PDF and discover: columns lost off the right edge, rows spilling onto a second page sideways, a table that fits on screen now split across seven pages with three columns each.
Excel and other spreadsheet programs do not treat a PDF page the way they treat a screen. A screen scrolls; a page has edges. The fix is almost always about telling the spreadsheet where the page edges are — and it takes less time than re-typing the data.
Spreadsheets have a "print area" and a print scale, and both are set independently of what you see on screen. Three things cause the cut-off:
In Excel these live under Page Layout → Page Setup. In Numbers, LibreOffice Calc, and Google Sheets the names differ but the concepts are identical.
1. Orientation. A wide table usually wants landscape. This alone fixes a large share of "columns cut off" complaints.
2. Scale / "Fit to". Set *Fit to: 1 page wide by N pages tall*. Fit to 1 page wide is the key setting — it makes the program shrink the content horizontally until all columns fit, and lets it flow vertically as many pages as needed. Without it, the program keeps the horizontal overflow.
3. Print area. Select the exact range you want and set it as the print area. This excludes stray data in far-off cells (a note in column ZZ, a formula off to the side) that silently widens the print range and causes the printed table to be squeezed into a tiny fraction of the page.
4. Margins. Narrower margins give the scale more room. If you are fitting 1 page wide and the result is unreadably small, the problem is rarely margins — it's usually column widths or a stray print range.
5. Print titles (repeat row/column headers). For a table that spans multiple pages, repeat the header row so page 2 and page 3 are still readable. Without this, the multi-page output is technically complete but practically useless.
This is the second problem after the columns are fixed. If fitting everything shrinks the text to a size nobody can read, you have a few options:
The honest test is: can a reader at normal zoom read the numbers without squinting? If not, no amount of fitting will help.
Every major spreadsheet has a page-break preview mode (Excel: *View → Page Break Preview*). It draws blue lines where the pages will split. Looking at it before exporting is the fastest way to catch cut-off columns — you can drag the lines, which adjusts the print area and scale.
If you only remember one thing from this page, remember this: check page-break preview before exporting, not after. It takes ten seconds and prevents the whole problem.
Rows spill sideways. The table is wider than tall, forcing portrait-orientation overflow. Switch to landscape or fit to one page wide.
Text overlaps in the PDF. Column widths too narrow for wrapped text; the spreadsheet clips or overlaps on export. Widen the relevant columns or enable wrap text before exporting.
Borders disappear. Much lighter hairline borders get lost at the scale-down; use a slightly heavier line weight for table borders than looks necessary on screen.
The PDF has extra blank pages. Usually a stray cell with formatting far outside the print area expands the used range. Define the print area explicitly to fix it.
Hyperlinks or images are missing. Some export paths drop them. If those matter, check the output carefully rather than trusting the export.
For a report you will print or send:
The check on the last page matters because that's where over-shrinking and stray ranges show up most often.
Related reading: are free online pdf converters safe, batch convert many pdfs at once, batch convert pdfs to jpg.
Why do right-side columns disappear in my PDF export?
Excel calculates print width based on column settings and zoom. If your total column width exceeds the default Letter page size, content truncates. Reduce font sizes, narrow wide columns, or switch to landscape orientation before exporting to fit all visible data within the printable area.
How do I stop headers from cutting off?
Use the 'Print Titles' feature to repeat specific rows at the top of each page. For single-page exports, ensure the header row fits within the top margin. Adjust top margin settings or shrink the header row height to prevent it from being clipped during rendering.
What if text still gets cut off vertically?
Row heights and cell wrapping impact vertical space. Ensure cells are set to 'Wrap Text' if content exceeds column width. Adjust row heights manually or use auto-fit. If rows overflow the page bottom, reduce font size or split content across multiple pages using print area settings.