You convert a price list or report from Excel to PDF, and the last three columns appear on page four — separated from the rows they belong to. Nothing is wrong with the converter. Excel prints to fixed-size pages, and your sheet is wider than one page.
Why It Happens
A spreadsheet has no natural page size. When you convert or print, Excel divides the sheet into pages based on paper size, orientation, margins and scaling. Wide sheets overflow to the right, and those columns get placed on separate pages.
The Fix, Step by Step (in Excel)
- Set the print area. Select only the cells you want, then *Page Layout → Print Area → Set Print Area*. Empty columns and scratch calculations disappear from the PDF.
- Switch to landscape. *Page Layout → Orientation → Landscape* gives much more width.
- Fit columns to one page. In *File → Print*, change *No Scaling* to Fit All Columns on One Page. Rows can still flow onto more pages, which is fine.
- Narrow the margins to *Narrow* for a little extra space.
- Repeat header rows. In *Page Setup → Sheet*, set *Rows to repeat at top* so headings appear on every page.
- Export: *File → Save As → PDF*.
If You Do Not Have Excel
Upload the file to Excel to PDF. The converter follows the page settings stored in the workbook, so the most reliable results come from setting the print area and orientation before saving the file. Google Sheets users can set *Fit to width* in the download-as-PDF options.
When Text Becomes Too Small
Fitting 25 columns onto one landscape page produces unreadable text. Options:
- Hide columns the reader does not need (internal IDs, notes, formulas).
- Shorten headers and wrap text in the header row.
- Use A3 paper size if the PDF will be viewed on screen or printed on large paper.
- Split the table into two logical tables on separate sheets.
Before-and-After Example
| Setting | Result |
|---|---|
| Portrait, no scaling | 18 columns spread across 3 pages wide |
| Landscape, no scaling | Across 2 pages wide |
| Landscape, fit all columns | 1 page wide, readable at 9 pt |
| Landscape, fit all columns, 4 columns hidden | 1 page wide, comfortable at 10 pt |
Final Checks
- Open the PDF and confirm every row lines up with its columns.
- Check that the header repeats on each page.
- If the file is large because of images or logos, run Compress PDF.
For more on the conversion in general, see our Excel to PDF guide. Going the other way, PDF to Excel turns PDF tables back into spreadsheets.
