How to Save an Excel Sheet as a PDF That Fits the Page
You save a spreadsheet as a PDF and open it to find the last three columns stranded on page 4, the header row missing from every page after the first, and a total you cannot connect to anything. The sheet looked fine on screen. The problem is that Excel does not export the screen. It exports what would come out of a printer.
That means the fix is not in the PDF step at all. It is in the page setup you do just before it.
Why Excel splits your sheet across pages
A spreadsheet has no page size. Excel borrows one from your printer settings, usually Letter or A4 in portrait, and cuts the used range into page-sized tiles, working down first and then across. A sheet 20 columns wide ends up as one run of pages for columns A to H and a second run, pages later, for the rest.
Before exporting, open View, Page Break Preview. The blue lines show exactly where the PDF pages will break, and you can drag them.
Set the page up before you save
Work through these in order and stop when the preview looks right.
- Set Page Layout, Orientation, to Landscape. On its own this fixes most moderately wide sheets.
- Select the cells you want and choose Page Layout, Print Area, Set Print Area. Stray formatting far to the right is a common reason Excel thinks the sheet is wider than it is.
- In the Scale to Fit group, set Width to 1 page and leave Height on Automatic. Every column fits and the rows carry on down extra pages.
- Choose Page Layout, Print Titles, and set Rows to repeat at top to your header row, so every page has column names.
- If the text is now too small, pick a larger paper size under Page Layout, Size. A readable A3 page beats an unreadable A4 one.
The same choices appear under File, Print, in the scaling dropdown that starts on No Scaling:
| Option | What happens | Good for |
|---|---|---|
| Fit Sheet on One Page | Everything shrinks onto one page | Small tables and one-page summaries |
| Fit All Columns on One Page | Every column fits, rows flow onto more pages | Long lists and ledgers |
| No Scaling | Actual size, broken wherever the paper ends | Sheets you already laid out for print |
Fit Sheet on One Page is a trap for long sheets. A few hundred rows squeezed onto one page gives you a PDF that is technically one page and practically unreadable. If the preview text looks like a footnote, use Fit All Columns.
Save it as a PDF
- Choose File, Save As (or Save a Copy), and set the file type to PDF. On a Mac, use the File Format menu.
- Click Options and choose what to publish: the active sheet, the entire workbook, or just your selection. The default is the active sheet, which is why people find most of their workbook missing.
- Click Save, then open the result and page through it before sending.
File, Export, Create PDF/XPS Document opens the same dialog. If you export several sheets separately, or Excel produces more than one file, Merge PDF joins them in your browser without uploading anything.
On a Mac, recent Excel versions may offer a choice between an option for printing and one for electronic distribution. If the description says it uses an online service, pick the local one when the workbook holds payroll or client accounts.
What survives the export, and what does not
- Formulas become values. The reader sees results, not the working. Useful when you want to share a price without the calculation behind it.
- Hidden rows, columns and sheets are left out. Check nothing the reader needs is hidden.
- Gridlines and comments are off by default. A table with no borders is hard to follow across a row, so tick Page Layout, Sheet Options, Gridlines, Print if you rely on them. Comments and notes are set under Page Setup, Sheet.
- Document properties can come along. The author and company fields may travel with the PDF. Untick Document properties in the Options dialog, or edit them afterwards with Edit Metadata.
- A workbook password does not carry over. A protected .xlsx exports to an unprotected PDF. If the numbers are sensitive, see how to password-protect an Excel file and protect the PDF as well.
If you do not have Excel
Google Sheets exports through File, Download, PDF, with a settings panel where you can choose the current sheet, the workbook or a selection, set orientation, and scale to fit the width. LibreOffice Calc uses File, Export as PDF, and for scaling you set Format, Page Style, Sheet to fit the print range to the width. Numbers on a Mac uses File, Export To, PDF.
Google Sheets means the file goes into your Google account. LibreOffice and Numbers convert on your own machine.
Questions people ask
Why is only one sheet in my PDF?
Excel exports the active sheet by default. In the Save As dialog choose PDF, click Options, and set Publish what to Entire workbook. Hidden sheets are still left out.
Do formulas show up in the PDF?
No. The PDF holds the calculated results as they appear on the sheet, so the logic behind a number is not exposed. Cell values and formatting are what you see, nothing more.
Why do my cell comments and gridlines not appear?
Both are off for printing by default. Comments and notes are set under Page Layout, Page Setup, Sheet tab, and gridlines under Sheet Options, Gridlines, Print.
Can I convert Excel to PDF without Excel installed?
Yes. LibreOffice Calc opens .xlsx files and exports with File, Export as PDF, and Google Sheets offers File, Download, PDF. Check the result, because spacing and fonts can differ slightly from Excel.
Ready to try it yourself?
Why the last columns of your spreadsheet land on separate pages when you export to PDF, and the page setup that fixes it before you save.
Open the tool