Save an Excel Sheet as a PDF That Fits the Page

To save Excel as PDF, use File > Save As and pick PDF as the file type. The hard part isn't saving: it's making the PDF look right, because Excel builds the PDF from your print settings. This guide shows how to save a PDF on Windows and Mac, and how to fit the columns on one page, repeat the headers and avoid #### and cut-off text. It's for anyone sending a report, an invoice or a test answer as a PDF.

How to save Excel as PDF on Windows#

Excel has two routes on Windows, and both create the same PDF:

1. Go to File > Save As (or press F12).
2. Choose a folder, then set Save as type to PDF (*.pdf).
3. Click Options to choose what goes in: Selection, Active sheet(s) or Entire workbook. Tick Ignore print areas if you want everything, not just a set print area.
4. Choose Standard for the best quality, or Minimum size for email.
5. Click Save.

The other route is File > Export > Create PDF/XPS Document > Create PDF/XPS, which opens the same dialog. Your Excel file stays as it is; the PDF is a separate copy, and it won't update if you change the workbook later.

How to save Excel as PDF on a Mac#

On a Mac, the steps are almost the same:

1. Go to File > Save As (⌘+Shift+S).
2. Set File Format to PDF.
3. Choose Workbook to include every sheet, or Sheet for just the active one.
4. Click Save.

You can also use File > Print (⌘P), open the PDF menu at the bottom of the print window, and choose Save as PDF. That route follows the print settings exactly, which is useful if you've already checked the page in Print Preview.

Make the sheet fit on one page#

A PDF follows your page layout, so a sheet that's too wide spills onto a second page. Fix it before you save:

1. Go to the Page Layout tab.
2. In Scale to Fit, set Width to 1 page and leave Height as Automatic.
3. Set Orientation to Landscape if the sheet is wider than it is tall.
4. Check the result with File > Print (Windows: Ctrl+P; Mac: ⌘P).

In the Print screen, the scaling menu offers the same choices by name: Fit Sheet on One Page, Fit All Columns on One Page and Fit All Rows on One Page. "Fit All Columns" is usually best: every column fits across, and long lists continue onto more pages at a readable size. "Fit Sheet on One Page" squeezes everything, so a long sheet can become too small to read. The print setup guide covers margins, page breaks and page numbers in more detail.

Fix #### and cut-off text before you save#

The PDF shows exactly what the cells show. If a column is too narrow, numbers appear as #### and text is cut off, in the PDF too.

• AutoFit the columns. Double-click the right border of the column letter. On Windows, the key sequence Alt, H, O, I does the same. See how to AutoFit column width for every method.
• Format the numbers. Currency is Ctrl+Shift+$ on Windows and Control+Shift+$ on a Mac. Percent is Ctrl+Shift+% (Mac: Control+Shift+%). Bold the headers with Ctrl+B (Mac: ⌘B).
• Wrap long text. Use Home > Wrap Text for notes columns, so the text runs onto several lines instead of off the page.

A tidy summary line helps too. This formula joins a label to a formatted total:

="Total sales: "&TEXT(SUM(B2:B5),"$#,##0")

With sales of 4,200, 3,150, 2,600 and 2,500 in B2:B5, it returns Total sales: $12,450. TEXT turns the number into text with the format you give it, so the dollar sign and comma survive the join.

Repeat headers and choose what prints#

On a long report, page 2 of the PDF has no headers unless you ask for them:

1. Go to Page Layout > Print Titles.
2. Click in Rows to repeat at top and click the header row, for example row 1. Excel writes $1:$1.
3. Click OK.

Now every page of the PDF starts with the header row. Note that freeze panes only affect the screen; they don't repeat headers in a PDF.

To save just part of a sheet, select the range and choose Page Layout > Print Area > Set Print Area, or pick Selection in the PDF options. Hidden rows and columns don't appear in the PDF, which is handy for leaving out helper columns. The guide to hiding and unhiding rows and columns shows how.

Save several sheets or the whole workbook#

To put more than one sheet in a PDF:

• Some sheets: hold Ctrl (Mac: ⌘) and click each sheet tab, then save as PDF with Active sheet(s) selected.
• Every sheet: choose Entire workbook in Options (Mac: Workbook).

Each sheet uses its own page settings, so set the scaling on every sheet you include. Remember to click a single tab afterwards: while several tabs are selected, anything you type goes into all of them.

A PDF is for reading and printing, not for working with the data. If someone needs to use the numbers, send the workbook or a CSV as well; the comparison of CSV vs XLSX explains which to choose.

Common PDF problems and fixes#

These are the issues people hit most:

1. Extra blank pages. A stray format or space far below the data extends the print range. Set a print area, or clear the unused rows.
2. Tiny text. Fit Sheet on One Page shrank a long sheet. Use Fit All Columns on One Page instead.
3. No gridlines. Gridlines don't print by default. Tick Page Layout > Gridlines > Print, or add borders to the table.
4. Only one sheet saved. The default is the active sheet. Choose Entire workbook (or Workbook on a Mac).
5. Wrong numbers. The PDF is a snapshot. Make sure the data is final, and save a new PDF after any change.

Practise it#

A PDF only looks as good as the formatting behind it. Practise formatting shortcuts in a live spreadsheet: you bold headers and format currency and percentages from the keyboard, with each step checked instantly. Then try the more formatting lesson for comma style and dates, and the TEXT exercise on this page.