The Spreadsheet Looked Perfect on Screen. The PDF Cut Off Three Columns. Here Is Why.
The spreadsheet was complete: twelve columns of monthly revenue data, a summary row at the bottom, and a chart that pulled from the table. On screen in Excel, it looked exactly right. Then the client opened the PDF.
The chart was on a second page, separated from the data. Three columns were cut off. The fonts were smaller than expected. The client called to ask if she had received the wrong file.
She had not sent the wrong file. She had sent a spreadsheet that was not configured for printing, and Excel's default PDF export treated it like one. This failure mode is consistent enough to be documented in Microsoft's own support articles, and it exists because of a fundamental architectural difference between how spreadsheets and documents relate to page boundaries.
Why Spreadsheets and Page Boundaries Conflict
A spreadsheet's natural unit is the cell. The grid expands indefinitely in both directions with no concept of a page boundary. Word processing applications like Microsoft Word model documents as sequences of pages: every character you type goes onto a page, and when a page fills, a new one begins automatically. Excel works the opposite way: you type in cells, and page boundaries are a secondary overlay that you apply to the grid when you want output.
PDF, the Portable Document Format, was developed by Adobe Systems and released in 1993, designed specifically as a fixed-layout, page-based format. Adobe's founder John Warnock described the goal in an internal memo as "describing the appearance of text, graphics, and images on pages" in a way that is fully portable across devices and operating systems. PDF pages have defined dimensions. Content outside those dimensions does not exist in the file. When spreadsheet content is forced into that page-based model, something has to give.
When Excel converts a spreadsheet to PDF without explicit print configuration, it applies defaults inherited from whatever printer settings are saved in the file. If a previous user printed to a different paper size, or if the file was created on a system with different default margins, those settings carry forward invisibly. The result can be a page size that does not match any standard or margins that don't match what the current user expects.
The most common outcome of a misconfigured export is that columns that extend beyond the right page margin appear on a continuation page rather than being scaled down to fit. A 12-column spreadsheet designed for a wide monitor exports across three PDF pages not because the data is too long, but because each page is narrow.
How Excel Determines Page Breaks
Excel's page break algorithm works column by column and row by row. Starting from cell A1, it fills each page with as many columns as will fit within the page width defined by the current margin settings. When it reaches the margin boundary mid-column, it pushes the remaining columns to the next page. The algorithm does not understand which columns are related to each other or which visual groups should stay together. It only knows pixel widths and page dimensions.
The Page Layout view in Excel, accessible from the View menu, renders the spreadsheet with page boundaries shown as dashed lines over the data, so you can see exactly where breaks will fall before exporting. The Print Preview, accessible from File, shows the multi-page output in the proportions it will appear in the PDF. These two views show problems that the default Normal editing view does not.
The three most useful configurations for fixing layout problems before export are: Orientation: switching from portrait to landscape more than doubles the horizontal space available per page, which is the single most effective fix for wide spreadsheets. Scaling: the Fit Sheet on One Page option under Page Layout shrinks all content proportionally until the entire sheet fits within one page. This preserves column relationships but reduces font size. At very large column counts, the text may become too small to read comfortably. Print Area: selecting a range of cells and designating them as the print area tells Excel to export only those cells, ignoring everything outside the selection. This prevents adjacent worksheets or data entry areas from appearing in the output.
What Changes When Excel Exports to PDF
Understanding what the conversion does and does not preserve prevents misuse of the output. Formulas survive only as their computed values. A cell displaying the result of =SUM(B2:B13) exports as the number that formula produced at the moment of export. The formula itself is not embedded in the PDF. This is correct behavior for a document format: the PDF shows what the spreadsheet displayed, not the mechanism behind the display.
Interactive elements have no equivalent in PDF. Dropdown menus created with data validation show only the value that was selected when the export ran. The other options in the dropdown are not visible in the PDF and cannot be activated. Filters applied to columns are invisible: the PDF shows only the rows that were visible in the filtered view, with no indication that other rows exist or that the data has been filtered. A reader receiving a filtered Excel PDF cannot know that they are not seeing the complete dataset.
Comments and cell notes export as annotations in the PDF only if the print setting for comments is configured to show them at the time of export. The default is often None, meaning the PDF contains no indication that comments were attached to cells. Someone reviewing an annotated spreadsheet without changing this setting sends a PDF that looks complete but is missing all the contextual notes.
Charts export as static images embedded in the page at their current position. If the chart was positioned to overlap with cells on the spreadsheet, it may obscure those cells in the PDF, depending on the chart's layering order. If a page break falls within the chart's bounding box, the chart may be split across two pages with the top portion on one page and the bottom on the next. Excel will sometimes push the entire chart to the next page rather than split it, which is why charts frequently appear separated from the data they display.
Common Export Scenarios and Their Solutions
The revenue report scenario at the start is the most common: a wide table where the right columns disappear. The fix is landscape orientation combined with Fit to Width rather than Fit Sheet, which constrains only the column layout without shrinking row heights. If the font becomes illegibly small, reducing the column widths in the spreadsheet to remove unnecessary whitespace often recovers enough space.
The separated chart scenario is the second most common. Charts behave as floating objects in Excel. Moving the chart to its own worksheet creates a dedicated chart sheet that exports cleanly as its own PDF page. If keeping the chart on the same sheet as the data is a requirement, manually checking the chart's position relative to page breaks in Page Layout view and adjusting the chart size or position prevents the split.
Conclusion
The wrong-paper-size scenario occurs when a file was last modified on a system set to a different locale. US-standard paper is 8.5 by 11 inches. European A4 paper is 210 by 297 millimeters, which is slightly narrower and longer. A spreadsheet created on a US system that is exported to PDF on a European system with different default printer settings may produce a page size that matches neither A4 nor US Letter. Explicitly setting the paper size in Page Layout before export prevents this.
For spreadsheets already configured with appropriate print settings, the conversion to PDF preserves those settings and produces output that matches what was designed.
Frequently Asked Questions
Why do some columns not appear in my Excel PDF export?
Columns that extend beyond the page margin in your print configuration get pushed to a new page or cut off entirely. Set the page orientation to landscape and use the Fit to Page scaling option to include all columns in the output.
Why is my chart on a separate page from the data in the PDF?
Excel positions charts relative to the cell grid. If the chart overlaps a page break, it gets pushed to the next page. Adjust the chart size and position, or move it to a separate sheet with its own print area.
Do Excel formulas export to PDF?
No. Formulas are replaced by their computed values. The PDF shows only the results of calculations, not the underlying formulas. This is intentional behavior: a PDF is a visual representation, not a functional spreadsheet.