Spreadsheets do not have pages until you give them some
A Word document knows where its pages end. A spreadsheet does not. A worksheet is an unbounded grid, and turning it into a PDF means deciding where to cut it, which is why spreadsheet conversions disappoint people more often than any other kind. The conversion is rarely at fault. The workbook simply never said how it wanted to be printed, so something had to guess.
The good news is that the decisions live in your workbook and take about a minute to set. Get them right and the output is predictable every time.
Set these in Excel before converting
Values, not formulas
The output shows the calculated values stored in the workbook, which is what a PDF is for: a fixed record of what the numbers were at a point in time. Formulas are not recalculated during conversion, so if a workbook was saved before its last recalculation, the PDF preserves that stale figure faithfully. Open the workbook, let it recalculate, save, and then convert. This matters most for period end reporting, where the PDF often becomes the version of record that someone relies on months later.
What a spreadsheet quietly carries with it
Workbooks accumulate more than the sheet you are looking at. Hidden columns holding cost bases, a sheet of assumptions behind a customer quote, cell comments with internal commentary, filters concealing rows, and file properties naming the author and the department. Converting a copy rather than the original is the safe habit: delete what should not travel, then convert.
Once the PDF exists, treat it as final. Confirm the page count is what you expected, read the last page, and if the file is going outside your organisation strip its document properties with Redact PDF.
Going the other way
If someone sends you a PDF of a table and you need the numbers back, PDF to Excel reconstructs rows and columns from the page. It works well on machine generated tables and cannot do anything with a scan, since a scanned table is a picture rather than data.