SwitchPDF
All articles
Convert June 13, 2026 4 min read

Excel to PDF: Preserving Formulas, Formatting, and Print Areas

When your Excel-to-PDF conversion drops formatting or splits tables awkwardly across pages, the source spreadsheet usually needs a tweak.

Excel-to-PDF conversion is essentially "print to PDF." Once you know that, the tricks to get clean output become obvious.

What survives the conversion

Using SwitchPDF Excel to PDF (or any LibreOffice-based converter):

  • Cell values ✅ Preserved exactly
  • Visual formatting (fonts, colors, borders, alignment) ✅ Preserved
  • Charts ✅ Rendered as part of the page
  • Embedded images ✅ Preserved
  • Page headers/footers ✅ Included
  • Conditional formatting ✅ Applied at the value
  • Formulas ⚠️ Converted to calculated values — the PDF shows numbers, not formula expressions
  • Hidden rows/columns/sheets ❌ Skipped (which is usually what you want)

Three tricks for cleaner output

1. Set a print area before converting

In Excel: select the range → Page Layout → Print Area → Set Print Area. The PDF will only contain that range, ignoring the rest of the sheet. Without a print area, the converter exports the entire used range — which often includes stray cells at the edges.

2. Fit to one page wide

For wide spreadsheets (lots of columns), Excel's "Fit to: 1 page wide by 999 pages tall" print setting prevents column-splitting across pages. Set it in: Page Layout → Scale to Fit. The PDF will paginate vertically as needed but keep all columns on every page.

3. Use page breaks to control layout

Insert manual page breaks where you want the PDF to start a new page. View → Page Break Preview lets you drag the breaks visually. This is the only way to get truly predictable pagination for complex reports.

Multi-sheet workbooks

Each sheet becomes one or more pages in the output PDF. They appear in workbook sheet order. If you don't want a particular sheet exported, hide it before converting (right-click the tab → Hide).

When formulas matter

The PDF shows calculated values, not formulas. If you need the recipient to see the formulas themselves (e.g., for a teaching example), don't convert to PDF — share the .xlsx. Or take a screenshot of formula bar to embed in the document.

Common failure: tables split awkwardly

You set a print area but tables still break across pages mid-row. The fix: enable "Repeat row labels" (Page Layout → Print Titles → Rows to repeat at top). This keeps headers visible on every page and prevents most awkward splits.

Bottom line

Set a print area, fit to one page wide, use manual page breaks. Five minutes of spreadsheet setup gives you a clean PDF instead of fighting the tool.

Related articles