How to Convert Excel to PDF Without Cutting Off Columns

The classic problem with turning a spreadsheet into a PDF is that the last columns spill onto separate pages. To get every sheet onto readable landscape pages without splitting columns, open the Universal Document Converter, choose Excel to PDF (.xlsx), add the workbook and convert. Wide sheets are scaled to fit the page width, and pages break between rows, never through one. In Excel itself, the fix is Fit All Columns on One Page — both methods are below.

Convert in your browser

1. Open the Universal Document Converter. Office to PDF is selected.
2. Click Excel to PDF (.xlsx) and add your file — .xlsx, .xls or .csv.
3. Click Convert, then Download the PDF.

What you get:

• Every sheet in the workbook, one after another — not just the active one.
• Landscape A4 pages, which suit most tables.
• Wide sheets scaled to fit, like "fit to page width" when printing.
• Page breaks between rows, so no row is cut in half.

The pages are images of the sheets, so numbers can't be selected or copied from the PDF. For a PDF whose figures can be copied, use Excel's own export.

In Excel: fit all columns on one page

Excel prints exactly what its page setup says, so set that up first:

1. Go to Page Layout and set Orientation to Landscape.
2. In Scale to Fit, set Width to 1 page and Height to Automatic. (Or choose File › Print › Settings › Fit All Columns on One Page.)
3. Check the preview in File › Print.
4. Choose File › Save As (Windows) or File › Save As › File Format: PDF (Mac), and pick PDF.

To include every sheet rather than just the current one, in the Save As dialog on Windows click Options and choose Entire workbook. On a Mac, choose Workbook in the PDF options.

Google Sheets

File › Download › PDF opens export settings: choose Workbook or Current sheet, Landscape, and Scale: Fit to width. Google Sheets' PDFs have selectable text.

Make printouts readable

• Hide helper columns you don't want in the PDF before converting.
• Repeat the header row on every page in Excel (Page Layout › Print Titles › Rows to repeat at top), so long tables stay readable.
• Set a print area (Page Layout › Print Area) when only part of a sheet belongs in the PDF.
• Turn on gridlines or borders. Excel doesn't print its grey gridlines unless you tick Page Layout › Gridlines › Print, and without them long rows of numbers are hard to follow on paper.
• Very wide sheets become tiny when squeezed onto one page. Consider splitting the data into two narrower tables, or use a larger paper size.

After converting

• Joining a workbook PDF with a cover letter or invoice? Use the PDF Merger.
• Want two or four sheet pages on one printed sheet for a handout? N-up PDF arranges them.
• For a smaller file to email, try Compress PDF.
• Need to go the other way — a PDF table back into a spreadsheet? See how to convert a PDF table to Excel.

Frequently asked questions

Do formulas survive in the PDF?

A PDF shows the calculated values, not the formulas. Anyone who needs the formulas needs the .xlsx itself.

Does the browser converter upload my workbook?

No. It's read and converted in your browser, so financial data stays on your device.

Can I convert a CSV file?

Yes — the converter accepts .csv as well as .xlsx and .xls, which makes it a quick way to print exported data without opening a spreadsheet program.