An Excel spreadsheet that looks correct on screen often produces a PDF with broken layouts, cut-off columns, blank pages, or missing data. These problems are not random. Each one has a specific cause rooted in how Excel handles pagination and how PDF converters interpret spreadsheet layout settings.
Why Excel-to-PDF is harder than Word-to-PDF
Word documents have a concept of page size built into the document. You define margins, set the paper size, and Word flows text to fit those constraints. The document knows where each page ends. Converting Word to PDF is a matter of rendering that defined layout.
Excel spreadsheets do not have a fixed page size by default. They have infinite columns and rows, with content wherever you have placed it. The page boundary is only relevant when you choose to print. Until you configure print settings in Excel, the spreadsheet has no concept of what should appear on which page of a PDF.
When a converter turns an Excel file into a PDF, it must make decisions about pagination that Excel itself has not made. It must choose where to break the sheet across pages, which columns fit on a single page, and what to do when a row is taller than a page. If the spreadsheet's print settings were not configured before conversion, the converter uses defaults that often produce poor results.
It is worth separating two things that get discussed as one. Pagination — where the page ends — is genuinely undecided until you set print settings. The geometry of the grid is not: your column widths, row heights and merged ranges are all stored in the file. A converter has to make a judgement call about the first and has no excuse for getting the second wrong.
The most common layout failures and their causes
Columns cut off at the right edge: the spreadsheet has more columns than fit on one page width, and the converter is using portrait orientation with default margins. The fix is to configure the spreadsheet to scale columns to fit the page width — a print setting in Excel labeled Scale to Fit — or to switch the PDF output to landscape orientation.
Blank pages between content: columns or rows extend far beyond the visible data, either because cells were accidentally formatted or because the spreadsheet was generated programmatically and has trailing empty rows. The converter treats the entire used range as content, including the empty parts. Delete trailing empty rows and columns before conversion.
Repeated headers missing from continuation pages: Excel has a setting for print titles — rows and columns that repeat on every page. If this setting is not configured, page two of a multi-page conversion shows data without the column headers that explain what the data means. Set the row-to-repeat-at-top setting in Excel's Page Layout before converting, or choose a converter that detects and preserves this setting.
Inconsistent row heights across pages: some converters ignore the row heights stored in the file and substitute a uniform height of their own. Data that fits in a configured row height then overflows or is clipped in the converted PDF. This one is worth checking on any converter you rely on, because a spreadsheet actually records a height for every row it has customised — a converter that produces uniform rows is discarding information the file gave it.
How to prepare an Excel file for accurate PDF conversion
Use Print Preview in Excel before converting. What Print Preview shows is what the PDF output should look like. If Print Preview shows the layout you want, the converter will produce a matching result when given the configured file. If Print Preview shows problems, fix them in Excel before converting.
Set explicit page breaks for long spreadsheets. Excel's manual page break feature lets you define exactly where each page ends, which is more reliable than letting the converter make page break decisions. Go to Page Layout, then Breaks, to insert manual page breaks at the rows where you want page divisions.
Choose an output page size and orientation that matches your content. Most spreadsheets are wider than they are tall and benefit from landscape orientation. If the spreadsheet has many narrow columns, portrait with smaller margins may be better. Test both orientations with Print Preview to find which fits the content more naturally.
Multi-sheet workbook handling
Multi-sheet workbooks raise a question that single-sheet files do not: which sheets become part of the PDF, and in what order? Excel's default behavior when printing or exporting to PDF is to include only the currently active sheet. Users who expect all sheets to be exported are routinely surprised when their multi-tab financial model produces a PDF containing only the Summary tab they happened to be viewing.
To export all sheets, the print scope must be set to Entire Workbook before the export runs. In Excel, this is the Print What dropdown on the print preview screen, with Entire Workbook as one of the options. Once set, every sheet in the file is included in page order, with each sheet starting on a new page.
The order of sheets in the output PDF matches the tab order in the workbook. If sheets are out of logical order — a common occurrence in workbooks that have been edited over time — the PDF reflects that disorder. Reorder tabs in the workbook before exporting to control output sequence. There is no setting in Excel to export tabs in a different order than they appear in the file.
Hidden sheets are excluded from the export by default. If a sheet is hidden in the workbook UI, it does not appear in the PDF output regardless of the print scope setting. This is usually the desired behavior, but it can cause confusion when users expect a sheet to appear and do not realize it has been hidden. Unhide all sheets before exporting if completeness is required.
The active-sheet default is Excel's, not a rule of the format, and converters differ. Filum's Excel to PDF includes every visible sheet in the workbook, in tab order, each starting on a new page — so there is no scope setting to remember and no risk of getting back only the tab you happened to be on. It follows Excel on hidden sheets, though: a sheet you have hidden is not drawn.
A useful intermediate option is to create a separate PDF per sheet rather than one combined PDF. Some workflows benefit from per-sheet outputs because the receiving system handles each sheet's data independently. To produce per-sheet PDFs, set the print scope to Active Sheet and run the export once per sheet rather than enabling Entire Workbook. This adds time but produces cleaner per-sheet outputs that can be archived, sent, or processed separately.
When a workbook contains both data sheets and chart sheets — a model with five data tabs and three chart tabs — the order in which they appear in the PDF matters for the document's narrative. Move chart sheets to follow the data sheets they summarise rather than letting Excel order them by creation date. The order in the PDF is the order in which a reader will encounter the content.
Choosing the right converter for spreadsheets
There are two honest approaches to this conversion, and it is worth knowing which one you are using. The first is to run a full spreadsheet application — Excel itself, or LibreOffice Calc — and print to PDF. That gives you the application's own layout engine and its own fonts, which is the fidelity ceiling. The second is to read the geometry the file already states and draw it. Which is possible because, contrary to how this conversion is usually described, an .xlsx is not silent about its layout: it records a width for every column you have adjusted, a height for every row you have customised, its merged ranges, its number formats, and its page setup.
Filum takes the second approach, and does it entirely in your browser. Your workbook is read on your own device and the page is drawn from its own numbers — every column edge and row edge in the output comes from a value stored in your file, along with your merges, fonts, fills, borders, alignment, orientation, margins, scaling, fit-to-page, manual page breaks and repeated print titles. Hidden sheets, rows and columns are skipped, exactly as they are when Excel prints. Gridlines are drawn only if your sheet is set to print them, which is also what Excel's own export does.
The tradeoff is stated rather than hidden. Filum draws the cell grid; it does not draw charts, images, shapes, conditional formatting or rotated text. Rather than let you find that out from the finished page, it lists what your file contained and the page does not — by name and count — every time you convert. Text has to be Latin script, because the output uses the standard built-in PDF fonts; a workbook containing Chinese, Japanese, Korean, Cyrillic, Greek, Arabic or Hebrew is refused with the exact cell named, instead of producing a page with characters missing. If your spreadsheet is mainly a data grid, that is a good trade for never uploading it. If it is mainly charts, use Excel's own export.
When nothing works
Some Excel files — particularly those with complex conditional formatting, embedded charts with custom themes, or data validation with complex rules — simply do not convert to PDF at acceptable quality using any automated tool. For these files, the most reliable approach is to open the file in Excel or LibreOffice, use the application's built-in export-to-PDF function, and save the result directly. This is not a limitation of any specific converter; it is the reality of complex spreadsheet rendering.
For spreadsheets that must be converted regularly as part of a workflow, investing time in configuring the print settings once — page size, orientation, scaling, print area, print titles — and saving those settings in the file means every subsequent conversion produces consistent output regardless of which tool processes it.