How to Convert Excel to PDF Keeping the Formulas Visible (and Everything Aligned)

A Word document has a natural page shape — 8.5 x 11 inches, text flowing top to bottom. When you print it, page breaks happen where the text runs out. A spreadsheet has a grid that can be arbitrarily wide and tall. When you export to PDF, something has to decide where columns and rows split across pages.

By default, Excel picks the page shape based on your printer settings. This is why the same spreadsheet exports differently on different machines. If nobody's configured print settings on this workbook, you get whatever Excel guesses — usually badly.

Before exporting to PDF, tell Excel exactly what to include:

1. Select the range of cells you want in the PDF.
2. Go to Page Layout → Print Area → Set Print Area.
3. Now go to File → Print to preview what the PDF will look like.

If you see columns cut off, or rows spilling onto extra pages, you have three levers to fix it.

The simplest solution is to tell Excel to scale the content to fit:

1. Page Layout → Scale to Fit.
2. Set Width to 1 page.
3. Set Height to 1 page (or "Automatic" for long spreadsheets).

Now everything shrinks to fit on one page. Downside: on a really wide spreadsheet, "fit to one page" makes the text uselessly tiny. For anything with more than 12 columns, consider switching to landscape orientation first (Page Layout → Orientation → Landscape).

The specific request "keep the formulas visible" usually means someone wants to audit or verify the math. To show formulas in cells instead of their calculated results:

1. Excel: Formulas → Show Formulas (or Ctrl + `).
2. Now every cell displays its underlying formula.
3. Export to PDF as normal.
4. Toggle Show Formulas off afterwards to return to normal view.

The formula view usually makes columns wider (formulas take more space than results), so re-check your print area after toggling it on.

If the recipient wants to verify formulas, honestly sending both files is often the right answer: the PDF for a quick read, the .xlsx so they can click into individual cells to see the formulas natively. Attempting to squeeze both a numeric summary and formula transparency into a single PDF often produces something worse than either alone.

For long spreadsheets that spill over multiple pages, repeat the header row so each page is readable in isolation:

1. Page Layout → Print Titles.
2. In "Rows to repeat at top," pick your header row (usually row 1).
3. OK.

Now every page of the PDF starts with your header labels — much easier to read than a wall of numbers with no context.

Once print area, scale, and orientation are dialled in, three ways to export:

1. Excel's built-in PDF export: File → Save As → PDF. Works well once you've done the print setup above.
2. The online Excel to PDF converter: drop the .xlsx, get a PDF. Uses the same underlying page-setup logic, so if your XLSX has print area set correctly, the output is clean.
3. File → Print → Save as PDF: often produces cleaner results than "Save As" for complex spreadsheets.

What comes through cleanly in the PDF:

• Cell values (numbers, dates, text).
• Conditional formatting (colours, icon sets, data bars).
• Charts (rendered as static images in the PDF).
• Cell borders and shading.
• Comments — sometimes; depends on your print settings.

What doesn't come through:

• Formula bar (the recipient sees the result, not the underlying formula, unless you toggled Show Formulas).
• Interactive filters and slicers (become static views).
• Cell comments unless explicitly enabled.
• Hidden columns and rows (unless you unhid them before export).

Excel to PDF isn't a one-click operation if you want a clean result. Set the print area, pick fit-to-width, use landscape for wide spreadsheets, repeat header rows for long ones. If you need formulas visible, toggle Show Formulas before export. Set it up once and every future export is quick.