You can handle this directly in your browser with our free pdf to word tool — nothing gets uploaded.
Converting an Excel workbook into a PDF is usually one click: File > Export > Create PDF/XPS (or File > Print > Printer: Microsoft Print to PDF). The problem is that Excel was designed for infinite spreadsheets, not fixed pages. The result is often a PDF with columns cut in half, blank pages, or data jumping to the wrong page.
This guide focuses on the Excel side — how to set print area, scale, page setup, and orientation so the exported PDF looks right. We finish with the cases where a spreadsheet simply is not the right tool, and where online PDF utilities become a useful fallback.
Before fixing anything, understand the three common failure modes:
All three come from the same root cause: the print range and the scale you hand Excel do not match what the PDF paper size can hold. Fix those two, and 90% of layout complaints disappear.
Excel has no concept of “my report is here, ignore the rest of the grid.” You must tell it explicitly.
A1:L48 and press Enter — this is faster than dragging.If you skip this step, Excel will print everything from the top-left corner to the last cell that has ever had any content, including stray spaces a hundred columns away.
Go to File > Print > Page Setup (or double-click the thin Page Setup margin strip in print preview, or Page Layout tab > Page Setup dialog launcher in the corner of the Page Setup group).
$1:$3 for top 3 rows repeating).Still in the Page Setup dialog, Sheet tab > Scaling:
Tip: after changing scale, click Print Preview and zoom out so you see 4–6 pages at once. That is where you catch column cut-offs, because Excel’s preview at 100% zoom lies to you about where the breaks fall.
Automatic page breaks are the source of “the table got split in the middle of a row.”
Before clicking Create PDF, run through:
Then File > Export > Create PDF/XPS Document, and open the produced PDF on your machine — do not trust Excel’s preview, trust the PDF.
There are three situations where fighting Excel’s layout engine is more expensive than working around it:
The rule of thumb: fix it in Excel first, because that is where the layout is actually defined. Use online tools as a last-mile formatting step, or when the document is not spreadsheet-shaped at all.
1. The PDF shows one extra blank page at the end. Why?
There is almost always a cell with content (a space, a zero, a stray 0.00 format) one column or one row past your real data. Go to View > Page Break Preview, look at the bottom-right of the used range, and delete it. Or Home > Find & Select > Go To Special > Blanks? No — use Find & Select > Formulas or Constants and clear the stragglers. Then re-export.
2. I set Fit All Columns on One Page and the text is now unreadable. What do I do?
You are cramming too many columns into one page. The honest fix is to redesign the report: move secondary columns to a second “detail” page, or split the table into two stacked sections with a repeated header. If you genuinely need all of it on one page, drop the custom scale to 60–70% and accept small text, or print on A3/Letter-landscape. Scaling a 24-column table onto A4 portrait at 100% is mathematically impossible; the tool is not broken, the table is too wide.
3. The PDF looks different on my phone than on my laptop. Same file.
Two possible causes: a very long single cell (wrapped text in a narrow column) that renders at different width on different DPIs, or a font that is not embedded. Open File > Options > General, confirm Always use these applications when opening files without an extension is not the culprit; for the PDF itself, re-export with File > Export > Change PDF Options > Minimum size (optimized for publishing) — this embeds fonts more aggressively. If the cell-wrap issue persists, set the problem column to a fixed width instead of AutoFit, which is what usually produces the cross-device difference.
---
In short: set the print area, force a fit-to-page scale, drag the page breaks where you want them, and verify in Page Break Preview before exporting. When the document is not actually a spreadsheet by nature, hand it to an online tool — NoFilePDF’s Excel to PDF, Compress PDF, and Images to PDF are free and cover the last-mile cases without installing anything.
Related reading: are free online pdf converters safe, batch convert many pdfs at once, batch convert pdfs to jpg.
Why does my Excel file look cut off when converted to PDF?
Set the print area precisely using the 'Page Layout' tab. Adjust margins to 'Narrow' or 'Custom' to ensure all columns fit. If headers repeat, enable 'Repeat Rows' in the top section. Scaling options like 'Fit to Page' often prevent horizontal overflow, keeping data visible without manual cropping.
How do I prevent long text from spilling into adjacent columns?
Enable 'Wrap Text' for affected cells so content expands vertically instead of horizontally. Alternatively, merge cells for wide headers. If using a print preview, reduce the font size slightly or increase column widths manually. These adjustments ensure text remains contained within cell boundaries during the PDF rendering process.
What causes gridlines to disappear in the final PDF?
Gridlines are visual aids in Excel and never print by default. To include them, go to 'Page Layout,' select 'Show Gridlines,' and set 'Black' as the color. Alternatively, add borders manually to specific ranges using the 'Borders' dropdown. This ensures structural lines appear in the PDF output.
How can I make column headers repeat on every page?
Navigate to 'Page Layout' and find 'Print Titles' under the 'Sheet Options' group. Click 'Print Titles' and specify the exact row number or range that should repeat at the top of each printed page. Confirm the range in the dialog box to ensure headers appear consistently throughout multi-page documents.