Exporting Excel to PDF Without Split Columns or Blank Pages
By PDF tools platform · Last updated August 26, 2026
This site doesn't have an Excel converter, and it doesn't need one: Excel can export PDFs itself. The common problems, such as columns spilling onto extra pages, blank trailing pages or tiny unreadable text, come from how the sheet is set up for printing, not from the export. This guide shows the setup that avoids them.
Why spreadsheets export badly
A spreadsheet has no pages, only a grid. When Excel produces a PDF, it slices the grid into page-sized pieces using your print settings. If those settings are the defaults, a wide table gets cut across several pages and stray cells far from your data can add blank pages.
The five settings that matter
1. Print area
Select the cells you want in the PDF, then use Page Layout, Print Area, Set Print Area. Anything outside it is ignored, which is the usual cure for blank pages caused by stray formatting.
2. Orientation
Wide tables almost always want Landscape. Portrait is the default and rarely right for more than a handful of columns.
3. Scale to fit
In Page Layout, set Width: 1 page and leave Height as Automatic. This shrinks the sheet to the page width without squashing it vertically. If the text becomes too small to read, the sheet is too wide; consider hiding helper columns.
4. Print titles
For tables that run over several pages, choose Print Titles and set the header row to repeat so each page is understandable by itself.
5. Which sheets
By default Excel can export just the active sheet or the entire workbook. Check the export options so you don't send a hidden working sheet by accident.
Preview before you export
Use File, Print and scroll through the preview. Look for columns cut at a page edge, a stray blank page at the end, and charts split across two pages. Fix those in the sheet and preview again.
Exporting
Use File, Export, Create PDF/XPS (or Save As, then PDF). Google Sheets has File, Download, PDF with similar page-setup choices. The result is a text-based PDF, so numbers stay searchable.
Things a PDF can't do for a spreadsheet
- Formulas aren't included, only the displayed values. That's usually the point, but keep the workbook.
- Recipients can't sort or filter. If they need the data, send the workbook too.
- Hidden rows and columns stay hidden, but check that nothing sensitive is still visible.
After the export
Once you have the PDF, the tools here can help with the next step: merge it with a cover letter, delete a stray page, or lock it with a password before sharing.