Fix Excel to PDF Issues
Excel exports go wrong in characteristic ways: columns get cut, rows wrap onto twenty pages, ##### shows up where numbers should be, charts blur. Here is how to fix every common issue.
Issue 1: Columns are cut off on the right
- Page Layout → Scale to Fit → Width = 1 page.
- Switch orientation to Landscape.
- Reduce column widths or font size before exporting.
Issue 2: One sheet exports to twenty pages
- Set a print area: Page Layout → Print Area → Set Print Area.
- Use Fit Sheet on One Page if the data really is small.
- Hide unused columns or rows that are silently inflating the print range.
Issue 3: Cells show ##### instead of numbers
At the chosen scale, the column is narrower than the formatted number. Either widen the column, reduce decimal places, or shrink the font. AutoFit (Format → AutoFit Column Width) usually resolves this in one click.
Issue 4: Headers do not repeat on every page
Page Layout → Print Titles → Rows to repeat at top → select your header row. Without this, a 50-row table gives readers no column labels after page one.
Issue 5: Charts are blurry
- Avoid pasting charts as images — keep them as native chart objects.
- Increase chart object size in the worksheet so PDF output has more pixels to work with.
- Confirm the converter exports vector graphics (PDF native), not rasterized images.
Issue 6: Conditional formatting disappears
Some converters strip conditional rules. Re-apply rules through Excel's standard menus (Home → Conditional Formatting), avoiding VBA-driven formats. After re-applying, exporting renders data bars, color scales, and icon sets correctly.
Issue 7: Hidden rows or columns appear in the PDF
- Right-click the row/column header → Hide (not Group).
- Confirm Print only the visible cells is enabled if your tool exposes it.
Issue 8: PDF is enormous
- Remove embedded images you do not need.
- Convert PNG screenshots to JPG to cut size by 60–80 percent.
- Delete unused worksheets before exporting.
- Compact pivot caches: PivotTable → Options → Data → uncheck Save source data with file.
Issue 9: Page breaks land in the wrong rows
Use the View → Page Break Preview mode. Drag the dashed blue lines to set breaks exactly where you want them. Excel respects manual breaks during export.
Issue 10: Number formatting changes after export
Locale-specific number and date formats sometimes flatten in conversion. Pre-format cells
with explicit Custom Format strings (e.g. #,##0.00 or yyyy-mm-dd)
rather than relying on auto-detection.