Excel to PDF on One Page: Stop Columns Spilling onto Extra Pages
Why Excel sheets split across pages when converted to PDF, and how to fit every column on one page with print areas, orientation, scaling and repeated headers.
Updated September 15, 20267 min read
To convert Excel to PDF on one page, fit the sheet to the page width instead of printing it at actual size, switch wide sheets to landscape, and set a print area so only the cells you mean to share are included. Columns spill onto extra pages because a spreadsheet paginates in two directions: a sheet wider than the paper does not shrink or wrap, it continues on a later page, and the reader of your PDF finds column H sitting alone on page four. Every fix below is a setting saved in the workbook, a setting chosen at conversion, or both.
Why columns end up on another page
A worksheet carries its own page setup: paper size, orientation, margins and a scale, which unless someone changed it is 100%. When the columns add up to more than the width of the paper at that scale, the overflow becomes separate pages. Depending on the page order, those pages come after every row of the first columns or interleaved with them — either way, a row's figures end up pages apart from its label.
A converter that respects the file reproduces that pagination faithfully, which is correct: the PDF looks the way the workbook says it should print. The fix is to change what the workbook says, or to override it when you convert.
Prepare the sheet in Excel first
These are steps you take in Excel itself, on the Page Layout tab. They are saved with the workbook, so every later print or conversion benefits.
Set a print area
Select the cells you want to share, then choose Print Area › Set Print Area. Working columns, notes and scratch calculations outside it stop taking up paper, and Excel saves the print area with the file.
Hide helper columns
Columns you need for the maths but not in the document can simply be hidden. Hidden rows and columns are not printed.
Repeat the header row
Choose Print Titles, and in Rows to repeat at top enter $1:$1 (or $1:$2 for two header rows). Every page then starts with the column labels. Microsoft notes that Excel for the web cannot currently repeat headers when printing; the desktop app can.
Fit to one page wide
In the Scale to Fit group, set Width to 1 page and Height to Automatic. All columns go on one page across, and rows continue down onto as many pages as they need.
Check the scale it chose
The Scale box shows how far Excel shrank the sheet. A low number means small text; Microsoft's advice is to change to landscape or a larger paper size before accepting it.
Tame wide text columns
One column of long descriptions can force everything else to shrink. Narrow it and turn on Wrap Text, so the text grows downwards instead of sideways.
The settings in our converter
Every layout control in Excel to PDF is free. By default each one follows the workbook, so a sheet you prepared in Excel converts exactly as you set it up; when a file arrives from someone else with no page setup at all, you can override it without opening Excel.
| Setting | Options | Use it when |
|---|---|---|
| Scaling | Automatic (the workbook's own), Fit to width, Fit to one page, Fixed % from 10 to 400 | Fit to width for a sheet wider than the paper |
| Orientation | From workbook, Portrait, Landscape | Landscape for a wide sheet |
| Paper | From workbook, A4, Letter, Legal, A3, A5, Tabloid | A3 or Tabloid when a wide sheet will be printed |
| Header rows | Repeat on every page; up to 10 rows, or 0 for the workbook's own print titles | Any table longer than one page |
| Columns | From workbook or Fit to content; wrap text that would be cut off | Text clipped by a narrow column |
| Sheets | First sheet, All sheets, or choose; optionally one PDF per sheet | Workbooks with several tabs |
Margins, gridlines, row and column headings and page order are there too. The workbook's print area is used by default and hidden rows and columns are left out, with a switch for each.
Fit to width shrinks as far as the columns require, down to the same 10% floor Excel uses. Sixty columns on one A4 width is legal and unreadable, so if the preview looks tiny, change to landscape, choose a larger paper size, or narrow the print area to the columns the reader needs.
What formatting survives
Fonts, cell fills, borders, merged cells, gridlines, pictures and headers and footers carry across, and number formats are applied, so dates, currencies and percentages read as they do in Excel rather than as raw serial numbers. The text in the PDF is real, selectable text.
Charts are the honest exception. They are not redrawn: each chart's place on the sheet is marked with a box reading "Chart (not converted)", so nothing vanishes without trace. If a chart matters to the document, export that sheet to PDF from Excel itself. The converter reads .xlsx, .xlsm, .xls and .ods workbooks, templates and CSV; binary .xlsb files are refused, and the Excel Viewer opens them instead.
On the free plan you convert one spreadsheet at a time, up to 25MB and 250,000 cells, with embedded pictures exported at Balanced quality. Pro converts up to 20 spreadsheets at once, keeps pictures at their original quality and can combine every workbook into a single PDF.
All the layout controls are free. It all runs on your device, not our servers — sensible for payroll, accounts and client data.
Convert Excel to PDFMulti-sheet workbooks and other routes
With several sheets selected you can produce one PDF containing all of them, or tick One PDF per sheet and get a separate file for each. To join PDFs made from different workbooks on the free plan, convert each one and then combine them in the PDF merger.
If your data is a CSV rather than a formatted workbook, CSV to PDF is the better fit: its fit-to-width never shrinks text below six points, and when a table is too wide for that, the remaining columns continue on further pages with the header repeated. For handing data to another program rather than a person, see converting Excel to CSV and JSON.
A final check before you send
- Count the pages. A two-sheet summary that arrives as eleven pages has a scaling or print area problem.
- Look at page two. The header row should be there; if it is not, turn on Repeat header rows.
- Zoom to 100%. If the figures need squinting at, the sheet was shrunk too far — try landscape.
- Search for charts. Any "Chart (not converted)" box means that sheet should be exported from Excel instead.
Frequently asked questions
How do I convert Excel to PDF on one page?
Choose Fit to width and Landscape when you convert, or set Scale to Fit to one page wide in Excel before converting. That puts every column on one page across while rows continue downwards. Fit to one page shrinks both ways, which only works for short sheets.
Why are my columns cut off when I convert Excel to PDF?
Either the sheet is wider than the paper and the extra columns moved to later pages, which Fit to width solves, or text is clipped because the column is too narrow and the next cell is occupied — exactly as in Excel. For that, choose Fit to content column widths or Wrap text that would be cut off.
How do I convert Excel to PDF without losing formatting?
Leave the settings on From workbook so the sheet's own page setup is used. Fonts, fills, borders, merged cells, number formats and pictures carry across. Charts are marked with a placeholder rather than redrawn, so export chart sheets from Excel itself.
Can I convert every sheet of a workbook into one PDF?
Yes. The converter starts with the first sheet only; choose All sheets, or pick the sheets you want, to get them in one PDF. Tick One PDF per sheet if you want separate files instead.
Is the Excel to PDF converter free?
Yes, including every layout control — orientation, paper size, scaling, header rows and gridlines. Free converts one spreadsheet at a time up to 25MB and 250,000 cells; Pro adds batches of up to 20, original picture quality and combining workbooks into one PDF.