How to Fit an Excel Sheet on One Page When Saving as PDF on Mac
Your spreadsheet looks fine on screen, but the PDF comes out as four pages with the last column stranded on its own. That is Excel doing exactly what it was told, and the fix lives in the page settings rather than in the PDF dialog.
Quick answer: In Excel for Mac, open the Page Layout tab, set Orientation to Landscape if the sheet is wide, then set Width to 1 page and Height to Automatic in the Scale to Fit group. Check the result in View > Page Break Preview, then save with ⇧⌘S and choose PDF as the file format.
Why Excel splits a sheet across several PDF pages
Excel has no separate "PDF layout". When you export to PDF it lays the sheet out exactly as it would for a printer: the chosen paper size, the margins, the orientation and a scale of 100% unless you change it. Any column that does not fit inside the printable width moves onto a new page, and any rows that do not fit vertically do the same.
That is why two sheets that look similar on screen behave so differently. A report with six narrow columns fits on a US Letter or A4 page without trouble. A model with twenty columns does not, and Excel breaks it up at the page edge rather than shrinking it, which is why a single column often ends up alone on page two.
The practical consequence is simple. Do not fight the PDF dialog. Change the page settings first, confirm them in a preview, and only then export. For the keyboard route to the Save As dialog, see our Save and Save As shortcuts guide.
Method 1: Scale to Fit on the Page Layout tab
This is the quickest route and the one to try first.
Click any cell on the sheet you want to export.
Open the Page Layout tab in the ribbon.
In Orientation, choose Landscape if the sheet is wider than it is tall.
In the Scale to Fit group, set Width to 1 page.
Leave Height on Automatic unless you truly need a single page.
Save as PDF.
Setting only the width is the version of this that works for most real spreadsheets. Excel shrinks the sheet just enough for every column to fit, and rows continue onto additional pages as they need to. Forcing Height to 1 page as well works for a small summary, but on a long table it shrinks the text until it is unreadable.
| Your sheet | Orientation | Scale to Fit setting | Result |
|---|---|---|---|
| A few columns, many rows | Portrait | Width: 1 page, Height: Automatic | Every column on each page, rows flow onto as many pages as needed |
| Many columns, few rows | Landscape | Width: 1 page, Height: Automatic | Wide table shrunk to the page width |
| A one-screen summary or invoice | Either | Width: 1 page, Height: 1 page | Everything on a single page |
| A long report with a header row | Portrait | Width: 1 page, Height: Automatic, plus Print Titles | Header row repeats on every page |
| You want exact control | Either | Scale: a percentage such as 80% | Fixed shrink, no automatic fitting |
The Scale to Fit group is greyed out if you already set a manual Scale percentage. Set Scale back to 100% first, or clear it, and the Width and Height boxes become available again. Excel for Mac labels can differ slightly between versions, so if you cannot see a group by that name, look for the same controls under the Page Setup dialog described next.
Method 2: The Page Setup dialog
The dialog gives you the same scaling controls plus margins, headers and print titles in one place.
Choose File > Page Setup.
On the Page tab, choose the Orientation and the Paper size.
Under Scaling, choose Fit to and enter 1 page(s) wide. Clear the tall box so it stays automatic.
Open the Margins tab and reduce the margins if you need more room. Narrow margins buy you a larger printed scale.
Click OK, then preview before you save.
Use this route when you also need a repeating header row or want to switch on gridlines. Both are on the Sheet tab of the same dialog.
Method 3: Fix it from the print dialog
Press ⌘P to open the print dialog. In the bottom-left corner of the macOS dialog there is a PDF menu, and Save as PDF inside it writes a PDF of whatever the print preview shows. This is a good way to see the result quickly, because the preview updates when you change the scaling options.
The catch is that the print dialog is only a preview of your page settings. If you change scaling here and the sheet still splits, go back to the Page Layout tab. If the function keys do not respond on your MacBook, our function keys guide explains the fn setting.
Check the result before you save
You can tell whether the layout is right without exporting at all.
View > Page Break Preview draws the page boundaries as blue lines over the sheet. Anything outside the white area will land on another page. You can drag the blue lines to move a break.
View > Page Layout shows the sheet as printed pages, with margins and headers, so you can judge the real size of the text.
The Print Preview in the ⌘P dialog is the final check.
Switch back to View > Normal when you are done, because Page Layout view makes editing slower on large sheets.
Choose orientation and paper size on purpose
Two settings matter more than people expect. Landscape gives a wide table roughly 40 percent more width than portrait on a standard sheet of paper, so the scaling Excel applies is gentler. And the Paper size should match where the PDF will be used: Letter for US recipients, A4 for most of the rest of the world. A PDF in the wrong size is scaled again when the other person prints it.
As a rule of thumb, if Excel has to shrink a sheet below roughly 60 percent to fit, the text will be hard to read on paper. At that point it is better to remove a column, hide helper columns, or split the sheet into two print ranges than to keep shrinking. Setting a print area, so that only the cells you want are exported, is the other way to keep a page readable.
Repeat header rows and show gridlines
When a long table runs over several pages, repeat the header so every page makes sense.
On Page Layout, click Print Titles.
On the Sheet tab, click the box next to Rows to repeat at top and select your header row.
While you are there, tick Gridlines under Print if you want cell borders to appear in the PDF. They are off by default.
Headings (the row numbers and column letters) can be printed from the same area, which is occasionally useful when the PDF is a review copy and people need to refer to a cell by address.
Common mistakes
Fitting height to one page on a long table. The scale collapses. Use Width: 1 page and leave Height on Automatic.
Changing the zoom slider instead of the scale. The zoom slider in the corner only changes what you see on screen. It has no effect on the PDF.
Forgetting a stale print area. An old print area from a previous export can cut off new columns. Choose Page Layout > Print Area > Clear Print Area and try again.
Saving the wrong sheet. Excel exports the active sheet by default. Choose the entire workbook in the export options if you need every sheet.
Hidden columns reappearing. Hidden columns stay hidden in the PDF, which is usually what you want, but check that you did not hide something you meant to show.
If the output still has empty pages or clipped columns after all of this, the cause is almost always a stray print area, a manual page break or content far to the right of your table.
Frequently asked questions
How do I make an Excel sheet fit on one page without shrinking it too much?
Switch to landscape, narrow the margins, hide columns the reader does not need, and only then use Width: 1 page. Each of those gives Excel more room before it has to scale the content down.
Why does my PDF have an almost empty last page?
Usually a cell far down or to the right contains something invisible, such as a space, a formula returning an empty string or a border. Press ⌃End to jump to the last used cell. If it is well outside your table, delete the extra rows and columns, or set a print area.
Does Fit to One Page change the actual spreadsheet?
No. The scale setting only affects printing and PDF export. Your cells, column widths and fonts stay as they were.
Can I save different sheets with different scaling?
Yes. Page setup is stored per sheet, so set the scale on each sheet separately before exporting the workbook.
Is there a keyboard shortcut for Fit to One Page?
Excel for Mac does not have a dedicated shortcut for it. The fastest route is ⌘P to open the print dialog and the Page Setup button, or the Page Layout tab. If you press Windows-style Alt sequences from habit, the Mac Excel Shortcuts app can run them for you.