About Excel to PDF
Excel is brilliant for working with data. It's terrible for sharing it. The recipient might not have Excel, or they have an older version that displays the formulas wrong. The print area you carefully set up gets ignored. A column header that looked fine on your monitor wraps into three lines on theirs.
Converting the sheet to PDF locks everything down. Page breaks, fit-to-page settings, headers and footers, and the print area all carry over the way you set them. The recipient sees a clean printable layout instead of a spreadsheet that scrolls forever.
What translates well
Cell values and formatting. Numbers, dates, currencies, percentages, and your custom format strings all render exactly as the cell displays them in Excel.
Charts and pivot tables. They come across as images in the PDF, in whatever layout they had in the workbook.
Multiple sheets. By default each worksheet becomes a separate section in the PDF, with the sheet name appearing as a heading. You can also pick which sheets to include if a workbook has tabs you don't want shared.
Print areas and page breaks. If you set a print area in Excel and tweaked the page breaks, the PDF respects them. If you didn't, the converter does a reasonable auto-fit.
Layout options
Fit to page is the most common pick. The whole printable area gets scaled to fit one page wide, which is what most readers want. The page can be as long as the data demands; long tables flow over multiple pages with the column headers repeating at the top of each.
Original layout keeps the Excel print settings as-is. Use this if you've already laid the workbook out for printing and you want the PDF to match.
Landscape orientation is automatic if a sheet is wider than it is tall. Override it if you want a specific orientation.
Things to know
Formulas are gone from the PDF. What carries over are the calculated values that the cell displayed at conversion time. The recipient sees the numbers, not how they were computed. If you need to share the live formulas, send the XLSX itself or a Google Sheets link.
Conditional formatting renders to its current state. So the red cells, the heatmap colors, the data bars all carry over as they appear, frozen at the moment of conversion.
Macros and VBA code are stripped. The PDF is a viewing format only, so the macros wouldn't have anywhere to run.
When you'd reach for this
Sending a monthly report to stakeholders who don't want to open Excel. They get a printable PDF, you keep the live workbook.
Filing tax documents. Most tax portals accept PDF and reject XLSX or XLS.
Archiving year-end financials. A PDF snapshot is the right way to preserve a frozen view that you can always reopen without worrying about format changes.
Locking in numbers before sharing. The recipient can't accidentally change a formula and then question you about why their copy doesn't add up.
How to make a spreadsheet print well
Open Page Layout view in Excel before converting. This shows you what the printed pages will look like, including where the page breaks fall. You can drag the breaks to better spots if Excel's auto-placement splits a logical section.
Set the print area explicitly if your sheet has scratch calculations or notes off to the side that shouldn't appear in the PDF. Page Layout, then Print Area, then Set Print Area. The PDF will respect this and only include what's inside.
If a sheet is wider than it is tall, set page orientation to landscape. The default portrait crops or shrinks wide sheets, which makes the numbers harder to read.
Add page headers with the document title and a footer with page numbers. The Page Layout tab has these as one-click options. They make the PDF feel like a finished report instead of a raw print dump.