Excel to PDF Cutting Off Columns? Fix the Page Setup

You convert a spreadsheet and the PDF shows columns A to H on page 1, then columns I to M turn up alone on page 5, long after the rows they belong to. Nothing's broken. The converter printed the sheet exactly the way the workbook's page setup told it to, and a fresh Excel sheet is set to portrait at 100% scale with no print area. Wide sheets don't fit that.

Why the fix belongs in Excel

Our Excel to PDF tool renders your file with LibreOffice, which behaves like a printer: it reads the page setup saved inside the workbook. Orientation, paper size, margins, scaling, the print area and any manual page breaks all come from the file itself. Change them there and the PDF follows.

One catch. Choices you make only in Excel's Print dialog, like Print Selection or Ignore Print Area, aren't saved into the workbook, so the converter never sees them.

The odd page order has an explanation too. When a sheet is both too wide and too long, pages go down first, then across. You get every row of columns A to H before the first page of I onwards, which is why the overflow columns seem to vanish until the end.

Make it fit before you convert

1. Open View → Page Break Preview. The blue lines show exactly where each page will end.
2. Go to Page Layout → Orientation and pick Landscape. That alone sorts out a lot of sheets.
3. In the Scale to Fit group on the same tab, set Width to 1 page and leave Height on Automatic. Excel shrinks the sheet just enough to fit every column, and rows flow onto as many pages as they need.
4. Select the range you actually want to share, then choose Page Layout → Print Area → Set Print Area.
5. Save the workbook and upload it.

Don't set both Width and Height to 1 page on a long sheet. You'll get one page of text too small to read.

Still too wide at a readable size?

• Hide the columns your reader doesn't need, like internal IDs or working columns. Hidden columns are left out of the PDF.
• Switch Margins to Narrow, and wrap text in long header cells so those columns can be slimmer.
• A bigger paper size under Page Layout → Size gives you more room, but only choose Legal or A3 if the recipient can actually print it.
• For tables that run over several pages, use Page Layout → Print Titles and set Rows to repeat at top. The header row then appears on every page.

Extra pages you didn't ask for

Every visible sheet in the workbook gets converted, and each one starts on a new page. A forgotten Notes tab or an old draft sheet will show up at the end. Delete it or hide it; hidden sheets are skipped.

Blank or near-empty pages usually mean something is sitting far outside your table: a stray value in column AB, or a cell someone formatted hundreds of rows down. Press Ctrl+End to see where Excel thinks the sheet ends. Clear whatever you find there, or just set a print area.

Fonts can shift things slightly

LibreOffice doesn't ship Microsoft's fonts. For Calibri and Cambria it uses metric-compatible stand-ins, so the widths match. A less common font may be replaced by one that's a little wider, and on a sheet that only just fits in Excel, that's enough to push the last column onto its own page. Leave some slack, or stick to the standard Office fonts for sheets you'll share as PDFs.

Common questions

Can I convert just one sheet from a workbook?

There's no sheet picker on our end, so it happens in Excel. Hide the other sheets, or right-click the tab, choose Move or Copy, tick Create a copy, and send it to a new book. Save that and convert it.

The recipient needs the numbers, not a printout. What then?

Send the .xlsx itself if you can. If all they have is the PDF, PDF to Excel pulls each table back into its own sheet, which beats retyping.