How to save an Excel sheet as a PDF on one page
Fit every column on one page in Excel for Windows, Excel for Mac and Google Sheets, keep the text readable and tidy up the finished PDF
By Metin Ersoy · Updated November 1, 2026
Why Excel splits a table across pages
A spreadsheet has no page size; a PDF does. When you save a sheet as a PDF, Excel lays it out on A4 or Letter paper exactly as it would print it. Anything wider than the paper is pushed onto extra pages, which is why a ten-column table often comes out as two pages: columns A–G on the first, H–J on the second.
The fix is the same in every program: decide what you want on a page before you save, using the print settings. Three settings do almost all the work:
- Orientation: landscape gives a wide table about 40% more room across.
- Scaling: shrink the sheet so all columns fit the width of one page.
- Print area: tell the program exactly which cells belong to the table.
Excel for Windows
- Open the sheet and go to File → Print. The preview on the right shows the pages the PDF will have.
- Under Settings, change Portrait Orientation to Landscape Orientation if the table is wide.
- Change No Scaling to Fit All Columns on One Page. Use Fit Sheet on One Page only for small tables; on a long list it makes the text unreadably small.
- Check the preview, then save: either pick Microsoft Print to PDF as the printer and click Print, or go to File → Save As (or Export), choose PDF and click Save.
The same scaling lives on the Page Layout tab in the Scale to Fit group: set Width to 1 page and leave Height on Automatic. That setting is saved with the workbook, so the next PDF comes out right as well.
To save more than the current sheet, click Options… in the Save As dialog and choose Entire workbook or Selection.
Excel for Mac
- Go to File → Print.
- If you only see a short dialog, click Show Details.
- Set Orientation to landscape and, under Scaling, choose Fit to 1 page wide. Clear the number for the height (or leave it blank) so long tables can continue onto further pages.
- Click PDF at the bottom left and choose Save as PDF.
You can also use File → Save As and pick PDF as the file format; it uses the same page setup.
Google Sheets
- Go to File → Download → PDF. A preview with export settings opens.
- Under Export, choose the current sheet, the whole workbook or only the selected cells.
- Set Page orientation to Landscape and Scale to Fit to width. Fit to page squeezes everything onto a single page, with the same small-text problem as in Excel.
- Under Headers & footers and Formatting, decide whether you want page numbers, the sheet name and gridlines.
- Click Export. The PDF is downloaded to your computer.
Keep long tables readable
For a list with hundreds of rows, one page is not the goal — one page wide is. A few settings make a multi-page PDF easy to read:
- Repeat the header row. In Excel, go to Page Layout → Print Titles and set Rows to repeat at top (for example, row 1). In Google Sheets, freeze the header row with View → Freeze, then tick Repeat frozen rows in the export settings.
- Print gridlines if the table has no borders: Page Layout → Sheet Options → Gridlines → Print. Without them, numbers float on a white page and are easy to misread.
- Narrow the margins. Narrow margins in the print settings give a little more room for the columns.
- Hide columns you do not need (internal notes, helper formulas) instead of shrinking everything to fit them.
Remove empty pages and cut-off edges
- Set a print area. Select the table, then Page Layout → Print Area → Set Print Area. Only those cells end up in the PDF, so stray formatting far below the table no longer creates empty pages.
- Move the page breaks. View → Page Break Preview shows blue lines where pages end; drag them to the edge of the table.
- Check the last column. If one narrow column still spills over, make a few columns narrower or wrap long headings onto two lines.
Tidy up the PDF afterwards
Once the PDF exists, a few small fixes are easier to do on the PDF itself than in the spreadsheet:
- Several sheets or workbooks saved as separate files: put them into one document with Merge PDF.
- Mixed page sizes after merging, or a portal that only accepts A4: use Resize PDF. The guide on converting a PDF to A4 explains why.
- A page that comes out sideways in the viewer: turn it with Rotate PDF. If you want the whole file in landscape, see how to make a PDF landscape.
- Too many pages to print: put two or four pages on one sheet with N-up; more ideas are in printing a PDF to save paper and ink.
- An extra page you did not need: remove it with Delete PDF pages.
Before you send it
A PDF of a price list, a payroll sheet or a budget often travels further than planned. Two quick checks:
- Hidden data: hidden rows and sheets are not exported, but everything visible is. Look through every page of the PDF, not only the first one.
- File properties: the author name and the original file name can stay in the PDF's properties. You can check and clear them with the metadata guide.
Going the other way — a table in a PDF that you need in a spreadsheet? See how to copy a table from a PDF into Excel.
Ready to try it? It is free and your file stays on your device.
Open Merge PDF