PDFVela — pdfvela.com

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 · 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

  1. Open the sheet and go to File → Print. The preview on the right shows the pages the PDF will have.
  2. Under Settings, change Portrait Orientation to Landscape Orientation if the table is wide.
  3. 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.
  4. 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

  1. Go to File → Print.
  2. If you only see a short dialog, click Show Details.
  3. 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.
  4. 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

  1. Go to File → Download → PDF. A preview with export settings opens.
  2. Under Export, choose the current sheet, the whole workbook or only the selected cells.
  3. 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.
  4. Under Headers & footers and Formatting, decide whether you want page numbers, the sheet name and gridlines.
  5. 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:

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

Excel to PDF questions

Why does my PDF have a page with only one or two columns on it?

The sheet is wider than the paper, so Excel moves the columns that do not fit onto extra pages. Set scaling to "Fit All Columns on One Page" (or Width "1 page" on the Page Layout tab) and switch to landscape; the columns then stay together.

The whole sheet is on one page but the text is tiny. What now?

The option "Fit Sheet on One Page" shrinks everything until it fits, which makes long tables unreadable. Fit only the width to one page and let the rows continue onto the next pages, with the header row repeated at the top of each page.

Why are there empty pages at the end of my PDF?

Excel prints every cell it thinks is in use, including cells that only have a border or a colour. Select the real table and set it as the print area, or delete the empty rows and columns below and to the right of it.

How do I put several sheets into one PDF?

In Excel, hold Ctrl (Cmd on a Mac) and click the sheet tabs before saving, or choose "Entire workbook" in the PDF options. If the sheets were saved separately, combine the files with PDFVela's Merge PDF tool.

Does saving as PDF include hidden rows, hidden sheets or comments?

Hidden rows, hidden columns and hidden sheets are left out, and comments are not printed unless you turn that on in page setup. The file name and author name may still appear in the PDF's properties, so check them before sending.