How to Print an Excel Sheet on One Page (and Save as PDF)
Last updated June 2026
Quick answer
To print an Excel sheet on one page, open the Page Layout tab, find the Scale to Fit group, and set both Width and Height to 1 page — Excel shrinks everything to fit a single sheet. The fast version is File → Print, then Fit Sheet on One Page from the scaling dropdown. To save a PDF, use File → Export → Create PDF/XPS.
How do you fit an Excel sheet on one page?
Set the print area first
Select only the cells you want to print, then go to Page Layout → Print Area → Set Print Area. This stops a stray value in a far-off cell from forcing extra pages and making everything tiny.
Choose landscape if the sheet is wide
Wide tables fit better sideways. On Page Layout → Orientation, pick Landscape so columns get the full width of the page before Excel starts scaling them down.
Scale width and height to one page
In the Scale to Fit group on the Page Layout tab, set Width to 1 page and Height to 1 page. Excel shrinks the print to fit a single sheet — both dropdowns must read 1 page.
Check it in Print Preview
Press
Ctrl+Pto open File → Print. The preview on the right shows exactly one page. If you skipped the Page Layout tab, just pick Fit Sheet on One Page from the scaling dropdown at the bottom of this screen instead.Narrow the margins if it's still cramped
On the Print screen, open the margins dropdown and choose Narrow to reclaim space at the edges. This often lets Excel scale less aggressively, so the text stays larger and readable.
Print
Confirm the preview shows one page, pick your printer, and click Print.
How do you save the sheet as a PDF?
Open Export
Go to File → Export → Create PDF/XPS Document, then click the Create PDF/XPS button. (You can also use File → Save As, then pick PDF from the file-type dropdown.)
Set what gets exported
Click Options in the save dialog to choose Active sheet(s), Entire workbook, or Selection. The same one-page scaling you set on Page Layout carries straight into the PDF.
Name it and publish
Type a file name, leave the standard (publishing online and printing) quality option selected, and click Publish. Excel writes the PDF and usually opens it for a final look.
| Option | What it does | When to use it |
|---|---|---|
| Fit Sheet on One Page | Shrinks both width and height to a single page | Small sheets you want on one piece of paper, no questions asked |
| Fit All Columns on One Page | Keeps width to one page; lets rows spill onto more pages | Wide tables with many rows — no column ever gets cut off mid-print |
| Fit All Rows on One Page | Keeps height to one page; lets columns spill onto more pages | Tall, narrow lists where you want every row on a single sheet |
Custom % (Scale box) | Scales to a fixed percentage you type, e.g. 85% | When auto-fit makes text unreadable and you want precise control |
If the result is too small to read, the fix is almost never "zoom in." Switch to Landscape, set Narrow margins, and tighten your print area — then let Excel scale. More usable space means a gentler shrink and bigger text.
Frequently asked questions
- Why is my Excel printout too small to read on one page?
- Excel shrank everything to fit. Switch to Landscape, choose Narrow margins, and set a tight print area so it has more room — then it scales less and the text stays larger.
- How do I repeat the header row on every printed page?
- Go to Page Layout → Print Titles, then in Rows to repeat at top click the row with your headers (for example
$1:$1). That header now prints at the top of every page. - Can I print just a selection instead of the whole sheet?
- Yes. Highlight the cells you want, press
Ctrl+P, then in the first settings dropdown choose Print Selection. Only the highlighted range prints, ignoring everything else on the sheet. - How do I change the paper size of the PDF?
- Set it before exporting on Page Layout → Size (choose Letter, A4, and so on). The PDF inherits whatever page size and orientation the sheet uses when you create it.