Excel PDF Cut Off, Blank Pages or Tiny Text on Mac: How to Fix It
The sheet looks right on screen, but the PDF has a column stranded on page two, four empty pages at the end, or text so small you need a magnifying glass. These are the most common complaints about exporting from Excel for Mac, and nearly all of them trace back to the print setup rather than the PDF itself.
Quick answer: Work through these in order. First check the Print Area and clear it if you did not set it on purpose. Then press ⌃End to see whether the used range runs past your data. Then open View > Page Break Preview to look for manual breaks, and finally check Scale to Fit and the orientation on the Page Layout tab.
Symptoms
The table below pairs each symptom with its usual cause. If yours is in it, you can jump to the fix. If not, the diagnostic checklist after it finds the cause step by step.
| What you see | Most likely cause | Fix |
|---|---|---|
| Last column alone on page 2 | Sheet is wider than the page at 100% scale | Width: 1 page in Scale to Fit, or landscape |
| Blank pages at the end | Used range extends past your data | Delete empty rows and columns, or set a print area |
| Part of the sheet missing | Stale print area | Print Area > Clear Print Area |
| Text far too small | Forced Height: 1 page on a long table | Set Height to Automatic |
| Table breaks in the middle of a row | Manual or automatic page break | Page Break Preview, then drag or reset breaks |
| No cell borders in the PDF | Gridlines printing is off | Tick Print under Gridlines on Page Layout |
| Chart cut in half | Chart straddles a page boundary | Move it, or fit the page width |
| Rows of #### instead of numbers | Column too narrow for the value | Widen the column, then export |
Why this happens
Excel for Mac does not create PDFs from a screen image. It runs the same layout engine it uses for a printer, which means every PDF problem is a print layout problem. The engine takes the used range, applies the paper size, margins and scale stored with the sheet, inserts page breaks where content runs out of room, and writes the result. Anything surprising in the PDF can be traced to one of those inputs.
There is also a reason the problem feels random. Page setup belongs to each sheet, not to the workbook, so one tab can export perfectly while the next is a mess. Settings are also remembered between exports. A print area that you set three months ago is still there.
Diagnostic checklist
Work through the steps in this order, because the early ones are the quickest to check and the most common.
1. Look for a stale print area
Open Page Layout > Print Area. If Clear Print Area is enabled, a print area exists. If you did not set it deliberately, choose Clear Print Area and export again. If you did set it deliberately, make sure it still covers any columns or rows you added since. Our guide on exporting only a selected range explains how print areas work.
2. Find the true last cell
Press ⌃End (on a MacBook keyboard, fn ⌃ →). Excel jumps to the last cell it considers used. If that cell is far below or to the right of your table, Excel will print up to it, and everything in between becomes blank pages. Our guide to Go To Special shows how to select the last cell directly.
To reset the used range, select every blank row below your data, right-click and choose Delete, do the same for the blank columns to the right, then save the file. Clearing the contents is not enough, because formatting also counts as use. Save, and press ⌃End again to confirm the used range has shrunk.
3. Check for page breaks
Open View > Page Break Preview. Solid blue lines are manual page breaks, and dashed blue lines are automatic ones. If a solid line splits your table somewhere you do not want, drag it away, or choose Page Layout > Breaks > Reset All Page Breaks. Then go back to View > Normal.
4. Check the scale
In Page Layout > Scale to Fit, look at Width, Height and Scale. Three situations cause trouble:
Width: Automatic with a wide sheet. Columns run off the page. Set Width to 1 page.
Height: 1 page on a long table. The scale collapses and the text is tiny. Set Height back to Automatic.
A manual Scale below 100%. It greys out the Width and Height boxes. Reset it if you want automatic fitting. The full method is in our guide to fitting a sheet on one page.
5. Check orientation and paper size
Portrait is the default and is wrong for most wide tables. Switch to landscape. Then confirm the Size matches your audience, Letter in the US and A4 in most other places. A mismatch can add margins or shrink content.
6. Check what is being exported
If the PDF has only one sheet, you exported the active sheet. If it has too many, a group of sheets may be selected. Our guide to saving all sheets as one PDF explains the choices, including how to ungroup.
Fixes for specific problems
Gridlines or borders are missing
Gridlines on the screen are not printed unless you ask for it. On Page Layout, under Gridlines, tick Print. If you want proper borders instead, apply them from the Home tab, because they will always print.
Row numbers and column letters are missing
Tick Print under Headings on the same tab. This is useful for review copies where people refer to cell addresses.
Text appears as ####
Excel shows #### when a number does not fit the column width. The PDF will show the same. Widen the column by double-clicking the border to the right of its header, then export again.
Charts or images are cut off
A chart that crosses a page boundary is split across two pages. Move it fully onto one page, or use Width: 1 page so the whole sheet is on one page width. Check that the chart sits inside the print area, otherwise it is clipped at the edge.
The PDF file is too large
Large embedded images are the usual reason. Compress the images in the workbook, or look for a smaller-file option in the Save As dialog when you pick PDF. Option names differ between versions of Excel for Mac, so read the labels rather than relying on a fixed position.
Prevention
Set up the sheet before you export it. Orientation, scale and print titles take thirty seconds and prevent every problem above.
Look at Page Break Preview first. It shows exactly where the pages will end, before you create anything.
Clear old print areas when you change the layout of a sheet.
Keep a template. If you export the same report weekly, build the page setup once and reuse the file.
Frequently asked questions
Why does my PDF look different from my screen?
Because Excel lays out for a page, not a monitor. Fonts, column widths and zoom all behave differently at print scale, so check the preview rather than trusting the screen.
Why are there blank pages after my data?
Excel thinks the sheet is bigger than it is. Check the last used cell with ⌃End and delete the extra rows and columns, or set a print area.
Does Excel for Mac have a separate PDF export engine?
No. It uses the same print layout whether the destination is a printer or a PDF, so a fix that works for printing works for PDF.
Why does the problem come back after I fix it?
Page setup is saved per sheet. If you fix one sheet, the others still have their old settings, and a sheet copied from another workbook carries its own.
Can I just print to PDF from the print dialog instead?
You can, with ⌘P and the PDF menu, but the output is generated from the same page setup, so it will show the same problems.