Excel to PDF Formatting Issues: Why Layout Breaks and How to Fix It

Cut-off columns are the most common Excel-to-PDF complaint. A wide spreadsheet spills across more columns than fit on a single page width, and the PDF only captures the first page's worth of content — leaving anywhere from one to twenty columns completely absent from the output. Excel's print area is the mechanism that controls what gets included in a PDF. If no print area is defined, Excel uses the 'used range' of the sheet, which can extend far wider than any single page. The page width in PDF is fixed (A4 is 21cm wide, US Letter is 21.59cm), and content that extends beyond this width is either printed on additional pages or cut off depending on your settings. The correct fix is to set the page to 'Fit to 1 page wide' in Page Layout → Scale to Fit. This tells Excel to shrink everything horizontally until all columns fit on a single page width, regardless of how many columns there are. The text may become small, but nothing is cut off. Alternatively, switch to landscape orientation, which gives 50% more horizontal space on the same paper size.

1. 1In Excel, go to Page Layout → Scale to Fit and set 'Width' to 1 page.
2. 2Alternatively, go to Page Layout → Orientation → Landscape to use the wider page dimension.
3. 3Use Page Layout → Print Area → Set Print Area to select only the columns you need in the output.
4. 4Preview with Ctrl+P (File → Print) before converting to see exactly how pages will break.

Charts embedded in Excel spreadsheets sometimes fail to appear in PDF output, showing as empty rectangles or disappearing entirely. This is a rendering engine problem that occurs particularly when converting via third-party tools or when charts use certain newer Excel chart types. LibreOffice, which powers LazyPDF's Excel-to-PDF conversion, has excellent support for basic chart types (bar, line, pie, scatter) but limited support for some newer Excel-specific chart types introduced in Excel 2019 and later, such as waterfall charts, histogram charts, and map charts. These chart types may render as blank boxes or be omitted from the output. For charts that need to appear accurately in the PDF, the most reliable approach is to convert from within Excel itself using File → Export → Create PDF/XPS. Excel uses its own rendering engine for this export, which natively supports all its own chart types. For charts that do appear but look wrong (colors off, wrong fonts), screenshot the chart in Excel at high resolution (2x zoom, then screenshot) and insert it as an image if accuracy is critical.

1. 1Identify which chart types fail to render — newer chart types (waterfall, funnel, map) are most likely to fail in LibreOffice conversion.
2. 2For critical charts, use Excel's native File → Export → Create PDF/XPS to preserve chart rendering.
3. 3For online conversion of files with complex charts, convert from Excel's desktop app rather than uploading to a web tool.
4. 4As a fallback, take screenshots of problem charts and insert them as images into the spreadsheet before converting.

An Excel file created on a computer configured for US Letter paper may produce a PDF with US Letter dimensions when the recipient expects A4 — or vice versa. This mismatch causes content that fit perfectly on the original page to be cut off or surrounded by unexpected white space on the converted PDF. Excel stores page size settings within the workbook file. When a workbook is transferred across regions or corporate environments, the paper size setting travels with it. If the receiving computer's default printer uses A4 but the workbook specifies Letter, the conversion may override the workbook setting with the system default — or it may honor the workbook setting and produce an unexpected paper size. Before converting, always explicitly set the paper size in Page Layout → Page Setup → Paper Size. Choose the standard your recipients use. Similarly, set margins explicitly rather than using defaults — US and European margin standards differ, and default margins vary by locale. These explicit settings take precedence over any system defaults during conversion.

When Excel splits a spreadsheet across multiple PDF pages, it uses automatic page breaks unless you define them manually. Automatic page breaks are calculated purely by content volume — a break is inserted wherever the content exceeds one page's height. This often splits tables in inconvenient places: a header row appears on page 1 while its data continues on page 2, or a related group of rows is split across two pages. Manual page breaks give you complete control over where page divisions occur. In Excel, click the row where you want a new page to start, then go to Page Layout → Breaks → Insert Page Break. You can insert as many breaks as needed, and they are preserved during PDF conversion. For spreadsheets where keeping certain rows together is important (don't break a data group mid-table), use Print Titles. Go to Page Layout → Print Titles and specify which rows (or columns) should repeat on every page. This ensures your header row appears at the top of every PDF page rather than only on the first.

1. 1Go to View → Page Break Preview to see where automatic page breaks currently fall.
2. 2Click and drag automatic page breaks to more logical positions in the data.
3. 3Right-click on a row number and select 'Insert Page Break' to force a break before that row.
4. 4Set Print Titles (Page Layout → Print Titles) to repeat header rows on every page.

Custom fonts used in Excel spreadsheets may not be available on the conversion server, causing them to be substituted with system defaults. A spreadsheet using a corporate brand font or a specialized symbol font may render with incorrect characters or layout-disrupting size differences in the substituted font. For online converters including LazyPDF, which runs LibreOffice on a Linux server, the available fonts are the standard Ubuntu system fonts plus any manually installed additions. Fonts like Calibri, Arial, Times New Roman, and most common office fonts are available. Specialized design fonts, corporate fonts, and recently released fonts may be substituted. To ensure correct font rendering, either use standard fonts in your Excel file, or export to PDF from Excel's desktop application (which uses Windows' own font rendering and has access to all locally installed fonts). Conditional formatting and cell background colors generally convert well, but gradient fills and pattern fills have inconsistent support across LibreOffice versions.