How Do You Convert Excel to PDF and Fit It to the Page?
You fit an Excel sheet to the page by converting it with QuickCatPDF's Excel to PDF Fit to Page tool, which starts with Fit all columns on the page width and landscape pages already chosen. Every column of the sheet lands on the page, so nothing is cut off at the right edge, and rows simply continue on the next page.
If a single page is what you need, switch the page fit to Fit each sheet on one page before converting.
How to Fit an Excel Sheet to One PDF Page With QuickCatPDF
Getting a sheet onto the page width takes four steps.
- Click Select Excel files or drop your workbook on the page.
- Check the Page fit (fit to width is preset) and the Orientation, then pick the Paper size if you need A4, Letter, A3 or Legal.
- Choose Choose sheets under Sheets if you only want some sheets.
- Click Convert to PDF, then download the PDF.
Why Do Columns Get Cut Off in Excel PDFs?
Columns get cut off because Excel splits a sheet into pages at the printer's page width. When a sheet is wider than one page, the extra columns move to separate pages that print after all the rows, so a table ends up in pieces.
Fitting to the page width fixes this by scaling the whole sheet down until every column fits side by side. In our test, a 19-column sheet that split across two pages with the file's own setup fitted onto one landscape page width, and page one held every column from the first to the last.
Fit to Width or Fit to One Page: Which Should You Choose?
Fit to width is the safer choice for most sheets, because it only shrinks the sheet as much as the columns need. Rows still flow onto more pages, so the text stays readable.
Fit each sheet on one page shrinks the sheet in both directions until it fits a single page. That works well for summaries, invoices and dashboards, but a sheet with hundreds of rows becomes tiny on one page. QuickCatPDF warns about this next to the setting.
| Sheet | Recommended Page fit | Orientation |
|---|---|---|
| Wide table, many rows | Fit all columns on the page width | Landscape |
| One-page summary or invoice | Fit each sheet on one page | Portrait or landscape |
| Sheet already set up for printing | As set in the file | As set in the file |
Does Fit to Page Keep the Print Area?
Yes. Print areas set in the workbook are kept by default, and the fit applies to the print area rather than the whole sheet. That means you can keep a working area out of the PDF and still fit the important range neatly.
Choose Whole sheet under Print area if the saved print area is out of date. To control which sheets appear, see the Excel to PDF converter, which has all spreadsheet options, or Multiple Sheets Excel to PDF for combining sheets.
How Do Landscape Pages Help?
Landscape pages are about 40% wider than portrait pages, so a wide sheet needs less shrinking and its text stays larger. That's why landscape is preset on this page.
Choose Portrait for tall, narrow sheets, or As set in the file to keep each sheet's own orientation. The same settings work for ODS spreadsheets from LibreOffice Calc.
Word documents and slides convert the same way on Word to PDF and PowerPoint to PDF.
Frequently asked questions
How do I convert Excel to PDF without cutting columns?
Use Fit all columns on the page width, which is the default here. Every column is placed on the page, and long tables continue onto the next page.
Can I fit a whole sheet on one page?
Yes, choose Fit each sheet on one page. Each sheet becomes exactly one page; for very large sheets the text can become small.
Does it change my Excel file?
No, the page settings are applied only to the PDF. Your workbook isn't changed, and our server deletes it as soon as the conversion ends.
Is it free?
Yes, it's free with no sign-up and no watermark, for up to 10 files of 50 MB each at a time.
Can I set A3 or Legal paper?
Yes, Paper size offers A4, Letter, A3 and Legal for spreadsheets. A3 gives a wide sheet the most room.
Last updated: