Why Does Excel Cut Off Columns When Saved as a PDF?

What causes Excel to cut off columns in a PDF?

Excel cuts off columns in a PDF when the page's printable width is smaller than your data, usually because of wide margins, portrait orientation, an oversized column or the wrong print area.

• No print area: without one set, Excel guesses which cells to print, and can leave out the columns on the far right.
• Portrait orientation: a wide sheet rarely fits a narrower portrait page, so the extra columns spill onto a second page or vanish.
• Wide margins: the default one inch margins on each side eat into the usable width before your data even starts.
• One oversized column: a single column stretched far wider than it needs to be can push every column after it off the page.

How do I stop Excel from cutting off columns?

Setting Scale to Fit's Width to 1 page, with Height on Automatic, keeps every column on the page, and switching to landscape gives a wide sheet more room.

• Page Layout tab: open Scale to Fit and set Width to 1 page, leaving Height on Automatic so rows can still run across several pages.
• Landscape orientation: switch to landscape in Page Setup so a wide table gets more room before Excel starts shrinking it.
• Set the print area: select just the cells you need, then use Print Area in Page Layout, so Excel doesn't have to guess.
• Bigger paper: switching from Letter to a larger size like A3 can fit more columns without shrinking the text as much.
• Skip the settings: Excel to PDF renders the sheet for you and lets you pick page size and orientation in one step.

Why does my short report turn into dozens of extra pages?

A short report turns into dozens of extra pages when Excel's used range reaches far past your visible data, so it prints empty rows and columns as separate pages too.

• Check the real end of your data: press Ctrl+End to jump to Excel's idea of the last used cell. If it lands far past your table, that gap is being printed.
• A real case from the Adobe Community, November 2022: a user's certificate file normally ran 25 to 30 pages, but exported as 50 to 150 pages full of blank space.
• Reset the used range: delete the unused rows and columns rather than just clearing them, since clearing content alone doesn't always shrink what Excel thinks it needs to print.
• If you convert through an Adobe PDF add in rather than Excel's own Save As PDF, turn on its Fit to page width option too.

Will charts, images or borders shift when I convert to PDF?

Charts and images can shift position in the PDF if they're set to move or resize with the cells underneath them, even though colors, borders and fonts carry over exactly.

• Lock chart position: right click the chart, open Format Chart Area, then Size and Properties, and set it to not move or size with cells.
• Colors and borders stay put: the PDF is a snapshot of how the sheet prints, so shading, fonts and borders look exactly as they do in Excel.
• Preview first: switch to Page Break Preview, or use File then Print, to see the exact layout before you save, so nothing moves after you've checked it.

Try the tools

Try it on your own file. The tools are free and you don't need an account.