Easy PDFs
Windows 10 & 11 Buy license · $59.95
Convert

How to Convert Excel to PDF So It Fits on One Page

Convert Excel to PDF on one page without tiny text or cut-off columns. Fit to page scaling, print areas, landscape layout and multiple sheets in one PDF.

Updated 5 minute read The Easy PDFs team

To convert Excel to PDF on one page, set the scaling before you export: on the Page Layout tab, set Width to 1 page and Height to 1 page in the Scale to Fit group (or choose File > Print and pick "Fit Sheet on One Page" under Settings). Then use File > Save As, choose PDF and save. For wide sheets, switch to Landscape and set a print area around just the cells you need first, otherwise Excel shrinks empty columns and stray formatting too and the text ends up tiny.

This guide covers the scaling options, when "one page" is the wrong goal, how to remove blank pages, and how to put several sheets into one PDF.

The three fit options in Excel

In File > Print, the last setting (it says "No Scaling" by default) has three fit options. Choosing the right one makes more difference than anything else.

OptionWhat it doesBest for
Fit Sheet on One PageShrinks width and height to one pageSmall tables, dashboards, one-page summaries
Fit All Columns on One PageShrinks to one page wide, as many pages tall as neededLong lists, ledgers, price lists
Fit All Rows on One PageShrinks to one page tall, as many pages wide as neededTimelines and wide schedules

The same settings live on the Page Layout tab as Width and Height in the Scale to Fit group. Width 1 page with Height set to Automatic is the same as Fit All Columns on One Page, and it is the right choice for most real spreadsheets.

Step by step: Excel to a one-page PDF

  1. Select the cells you want and choose Page Layout > Print Area > Set Print Area. This stops Excel from including empty or stray cells.
  2. Set the orientation. Page Layout > Orientation > Landscape for sheets that are wider than they are tall.
  3. Narrow the margins. Page Layout > Margins > Narrow gives you a little more room.
  4. Set the scaling. In the Scale to Fit group, set Width to 1 page and Height to 1 page (or Automatic for long sheets).
  5. Check the preview in File > Print. Zoom in to see if the text is readable.
  6. Export. File > Save As (or Save a Copy), choose PDF as the type and click Save.

Look at the Scale percentage on the Page Layout tab after setting Width and Height. If it reads below about 60 percent, the PDF will be hard to read when printed. Consider fitting columns only, or using larger paper.

When one page is the wrong goal

Fitting 300 rows onto a single Letter page produces a PDF nobody can read. Better options:

  • Fit columns, not rows. Keep every column on the page and let the rows run onto more pages.
  • Repeat the header row on every page: Page Layout > Print Titles, then set "Rows to repeat at top" to your header row.
  • Use bigger paper. Legal or Tabloid in Page Layout > Size gives more room for wide sheets, and PDF readers can zoom.
  • Hide columns you don't need in the PDF, such as working columns and notes, before exporting.

Why does my Excel PDF have blank or extra pages?

Stray content or formatting far from your data

A single space, a border or a fill color in a distant cell extends the used range. Press Ctrl+End to see where Excel thinks the sheet ends. Delete the unused rows and columns beyond your data, or simply set a print area.

Page breaks in the wrong place

Open View > Page Break Preview. Blue lines show the page breaks; drag them to where you want them, or drag the outer edge to include only your data.

Every sheet was exported

If you exported the entire workbook, sheets you forgot about come along too. See the next section.

Exporting several sheets into one PDF

  1. Set the scaling, print area and orientation on each sheet. Page setup is stored per sheet.
  2. Choose File > Save As and select PDF.
  3. Click Options.
  4. Under Publish what, choose Entire workbook for every sheet, or select the sheets first (Ctrl+click the tabs) and choose Active sheet(s).
  5. Click OK and Save.

If some sheets come out in separate PDFs, or you want to combine sheets from different workbooks, export them one at a time and merge the PDFs afterwards. See how to combine PDF files into one.

Other ways to make a PDF from Excel

  • Print to Microsoft Print to PDF. Works from File > Print, but you lose some features of Save As, such as document properties and the option to export several sheets with their own settings. If it fails, see Microsoft Print to PDF not working.
  • Create the PDF in a PDF program. Easy PDFs makes PDFs from Word, Excel and PowerPoint files, so you can create a PDF from a workbook and then merge it with other documents, add page numbers or protect it, in one place.

Common problems and fixes

Text is too small

Too much is being squeezed onto one page. Fit columns only, switch to landscape, hide unneeded columns or use larger paper.

Gridlines are missing

Excel doesn't print gridlines by default. Tick Page Layout > Sheet Options > Gridlines > Print, or add borders to the cells.

Charts are cut off or stretched

Make sure the chart sits inside the print area, and check its properties are set to move and size with cells only if that is what you want.

Numbers show as ####

The column is too narrow at the printed scale. Widen the column before exporting.

Comments are missing

Choose how to print comments in Page Layout > Page Setup > Sheet tab, either as displayed or at the end of the sheet.

Going the other way

If you were sent a PDF of a spreadsheet and need the numbers back in cells, copying rarely works well. Convert it instead; see how to convert a PDF to Excel. Easy PDFs converts in both directions on your own PC, so financial sheets don't need to be uploaded to an online converter.

Frequently asked questions

How do I fit an Excel sheet to one page in a PDF?

In Page Layout set Width and Height to 1 page, or choose Fit Sheet on One Page in the print settings, then export to PDF.

Why does my Excel PDF have blank pages?

Formatting or stray content far outside your data stretches the print area. Set a print area around just the cells you need.

How do I save all sheets into one PDF?

In Excel choose Save As PDF, click Options and select Entire workbook.

Get three guides like this every month, plus software update notices.Subscribe →