Excel to PDF: How to Fit a Spreadsheet on One Page
By Chinmoy Biswas · Updated , first published
Convert a spreadsheet to PDF without preparation and you often get 14 pages: three columns on each, the last column alone on its own page, and no headers after page one. The conversion is not the problem. Excel follows the page setup saved in the workbook, and the default setup is portrait, 100% scale, no print area. Five minutes of setup fixes it, and the same settings carry over whether you export from Excel or use Excel to PDF on a device without Office.
Why does Excel split my sheet across so many PDF pages?
Because a worksheet has no page size, so Excel cuts it into page-sized tiles at 100% scale. Any column that does not fit on the first tile moves to a new page, and every stray cell far from the table counts as content.
A worksheet can hold 1,048,576 rows and 16,384 columns. A page is small by comparison: A4 is 210 × 297 mm and US Letter is 8.5 × 11 inches (see paper sizes on Wikipedia). With default margins, a portrait page holds roughly nine default-width columns and about 50 rows. A 15-column report therefore needs two pages side by side for every page of rows. The fix is to tell Excel three things: which cells count, which way the page is turned, and how much to shrink.
The five settings that fix it
Do these in order. Each one is saved inside the workbook, so you only set them once per sheet.
1. Set the print area
Select the cells you want in the PDF, then go to Page Layout > Print Area > Set Print Area. This excludes helper columns, notes to yourself and stray cells far below the table that silently add blank pages. To find strays, press Ctrl+End (Cmd+Fn+Right on some Mac keyboards): Excel jumps to the last cell it considers used. If that cell is far outside your table, a print area is the quickest cure.
2. Choose landscape for wide tables
Page Layout > Orientation > Landscape. Most financial and data tables are wider than tall, and landscape alone often halves the page count. Narrow margins (Page Layout > Margins > Narrow) gain a little more room without looking cramped.
3. Scale to fit the width
In the Scale to Fit group on the Page Layout tab, set Width to 1 page and Height to Automatic. Every column then fits across one page, and rows flow onto as many pages as needed. Setting both Width and Height to 1 page puts everything on a single page, which is right for a summary and wrong for a 400-row ledger.
Excel accepts scaling from 10% to 400%. As a rule, if the scale drops below about 60%, body text lands under 7 points on paper and people stop reading. Split the data or hide columns instead.
4. Repeat header rows
Page Layout > Print Titles > Rows to repeat at top, then click your header row. Every PDF page shows the column names, so page 5 is not a wall of unlabeled numbers. For very wide sheets that still span pages sideways, also set Columns to repeat at left so the row labels follow.
5. Check the preview and gridlines
File > Print shows exactly how pages will break, and View > Page Break Preview lets you drag the blue break lines. Under Page Layout, tick Gridlines > Print if the table has no borders, or apply borders for a cleaner look. Hide columns you do not want rather than deleting them; hidden columns and rows are left out of the PDF.
Should everything go on one page, or just one page wide?
One page wide is the right choice for most tables. A true single page only works when the data is short enough to stay readable, which in practice means up to about 40 rows in portrait or 12 to 15 columns in landscape.
| Your sheet | Setting | Result |
|---|---|---|
| Summary or dashboard, under 40 rows | Width 1 page, Height 1 page | A single readable page |
| Long list, few columns | Width 1 page, Height Automatic, portrait | All columns on every page, rows continue |
| Wide report, 10 to 20 columns | Width 1 page, Height Automatic, landscape | Readable if the scale stays above 60% |
| Very wide data, 25 or more columns | No fit to width; repeat the left columns | Pages run across, labels stay visible |
| Invoice or form designed for paper | 100% scale, print area set | Exact size, nothing shrunk |
How do I convert the file on each platform?
Every spreadsheet app can write a PDF, and the page setup above is respected by all of them. The menu names differ.
Windows and Mac
In Excel for Windows, use File > Save As and choose PDF, or File > Export > Create PDF/XPS Document. Click Options to pick Active sheet, Entire workbook or Selection. In Excel for Mac, use File > Save As and set the file format to PDF; a Workbook or Sheet choice appears below. Microsoft documents both routes in Save or convert to PDF. In Numbers, File > Export To > PDF offers a fit-each-sheet-to-one-page option.
Google Sheets
File > Download > PDF opens the print settings. Set Scale to Fit to width, choose Landscape, and under Headers & footers turn on Repeat frozen rows. Freeze the header first with View > Freeze > 1 row. To export part of a sheet, select the range and choose Selected cells in the first dropdown.
iPhone and Android
The Excel mobile apps can print to PDF, and the print options include a scaling choice, but print areas and print titles cannot be created there. If the workbook already has its page setup saved from a computer, the phone respects it. The simpler route on a phone is to open Excel to PDF in the browser and choose the workbook from Files or Downloads.
Without Excel, in a browser
On a Chromebook, a phone or a shared computer, Excel to PDF on this site converts XLSX, XLS, ODS and CSV files up to 25 MB. It uses the print areas, orientation, scaling and repeated rows saved in the file, so do the setup first and save. Office conversion needs a full office suite (LibreOffice) running on a server, so this is one of the few tools here that sends the file away: it goes over HTTPS, is converted and is deleted straight after. The tool page says so before you choose a file. Macro-enabled XLSM files are not accepted; save as XLSX first.
Common problems and fixes
Most bad spreadsheet PDFs come down to one of these.
- Hash marks (####) in cells: the column is too narrow for the number. Widen it before converting; scaling does not fix this.
- A blank page at the end: a stray space or format far from the table. Set a print area, or delete the empty rows and columns and save.
- Sheets in an odd order: sheets convert in tab order. Drag the tabs into the order you want.
- CSV looks plain: CSV files store no formatting or page setup. Open in Excel or Sheets, format, then save as XLSX before converting.
- Charts cut in half: in Page Break Preview, move the chart so it sits inside one page.
- Fonts look different after a server conversion: the converter does not have every commercial font. Arial, Calibri, Times New Roman and similar fonts convert reliably.
- Too many pages to send: delete pages afterwards with Remove Pages, or join the sheet PDF to a cover letter with Merge PDF.
When is a PDF the wrong format for a spreadsheet?
A PDF is the wrong format when the recipient needs to sort, filter, check formulas or reuse the numbers. A PDF holds displayed values only: formulas, hidden sheets, comments and data validation are all gone.
Send the workbook itself to an accountant or analyst who will work with the data, and a PDF alongside it as the fixed record of what was agreed. For upload portals that accept only PDF, keep the XLSX in your own records. If the PDF is too large for a portal, which happens with sheets full of pasted images, run it through Compress PDF.
Before you send the PDF
Open the PDF and check the first and last pages, a page break in the middle, and any sheet with a chart. Make sure rows with working figures are not showing, and that the file does not include sheets meant for internal use: converting a whole workbook includes every visible sheet. Check the total at the bottom of the last page against the workbook. It takes ten seconds and catches a print area that stopped one row short.
FAQ
Questions people also ask
How do I save an Excel sheet as a PDF on one page?
Set Width and Height to 1 page under Page Layout > Scale to Fit, then use File > Save As > PDF. This works well for sheets under about 40 rows. For longer tables, set only Width to 1 page so the text stays readable.
Why is my Excel PDF cutting off columns?
The sheet is wider than the page at 100% scale, so extra columns move to separate pages. Switch to landscape, set Width to 1 page in Scale to Fit, and set a print area so unused columns are not counted.
Can I convert Excel to PDF without Excel installed?
Yes. Google Sheets, Numbers and LibreOffice all export PDF, and the Excel to PDF tool on this site converts XLSX, XLS, ODS and CSV files up to 25 MB in a browser. It uses the page setup saved inside the workbook.
Does converting Excel to PDF keep formulas?
No. A PDF stores only the values shown in each cell at the time of conversion. Formulas, comments, hidden sheets and filters are not included. Send the workbook as well if the recipient needs to check or reuse the calculations.
Free tool
Try Excel to PDF
Turn a spreadsheet into PDF pages that open the same everywhere, with no formulas to break and no cells to edit by accident. The workbook is rendered by LibreOffice on a server and deleted as soon as the PDF is returned. Files are converted over HTTPS and deleted immediately.
Open Excel to PDF