Your spreadsheet has the official summary on the left, helper columns on the right, and some notes at the bottom. The PDF should only show the summary. Print Area solves this in one step.
How Print Area works
In Excel: select the cells you want in the PDF. Page Layout > Print Area > Set Print Area. From then on, every print and PDF export uses only those cells.
To clear: Page Layout > Print Area > Clear Print Area.
Multiple print areas
Excel supports multiple print areas per sheet — useful when you want, say, a summary table and a separate detail table without converting the whole sheet.
Hold Ctrl while selecting non-contiguous ranges, then Set Print Area. Each selected range prints on its own page in the PDF.
Print titles for multi-page
If your print area spans many pages, you usually want the header row to repeat. Page Layout > Print Titles > Rows to repeat at top > select row 1. Now every page in the PDF has the header.
Without this, the second page onwards has no column headers and becomes hard to read.
Verify with Print Preview
Always check Print Preview (Ctrl+P) before converting. The preview shows exactly what the PDF will contain. If anything looks off — wrong cells, wrong orientation, headers missing — fix it in Excel first.
Five seconds in preview saves five minutes of re-converting.
FAQ
Can I have different print areas per sheet?
Yes — print area is per-sheet. Each sheet can have its own area independently.
Will Print Area save with the file?
Yes — the print area persists when you save the xlsx. Future conversions use the same area.
How do I include the entire sheet again?
Clear Print Area. The PDF then includes everything.
Multiple selections — multiple pages?
Yes, each non-contiguous selection prints as its own page by default.
Set the print area, control the PDF. Convert your Excel to PDF with only what matters.