Converting Excel to PDF is built into Excel itself, but getting a clean result — one where the spreadsheet fits the page properly, prints on the right number of pages, and doesn't cut off columns — requires a few settings adjustments that many people skip. The default export often produces a PDF where the spreadsheet spills across more pages than expected or columns get chopped off at the edge.
Setting Up the Print Area Before Exporting
Before exporting, define the print area to control exactly what makes it into the PDF. Select the cells you want to include, go to Page Layout → Print Area → Set Print Area. This tells Excel to only export that selection rather than everything on the sheet including empty cells. Without this step, Excel often exports a large blank region to the right or below the data, producing a PDF with many empty pages.
If the spreadsheet is too wide to fit on a single page width, go to Page Layout → Scale to Fit and change the Width setting to "1 page." This scales the content horizontally to fit within one page width while keeping as many rows per page as the data requires. For wide financial models with many columns, this is often the difference between a readable PDF and one where half the data is missing.
Exporting From Excel
In Excel for Windows: File → Export → Create PDF/XPS. This produces a proper PDF with vector text and embedded fonts. Alternatively, File → Print → change the printer to Microsoft Print to PDF. Both work, but the Export route produces slightly better output for documents with charts and graphics because it handles vector content more cleanly than the print path.
In Excel for Mac: File → Save As → PDF, or File → Export → PDF. The Mac version also accepts Command+P → Save as PDF through the print dialog. For workbooks with multiple sheets, check whether you want to export the active sheet only or all sheets — Excel defaults to the active sheet, so if you want all sheets in a single PDF, change the selection in the export dialog.
Exporting From Google Sheets
Google Sheets exports via File → Download → PDF Document. The export dialog has more layout options than most people realize: paper size, orientation, scale (fit to width, fit to height, or a custom percentage), margins, and whether to include gridlines and row/column headers. Taking a minute to configure these settings before downloading produces a much more usable PDF than accepting the defaults.
For large spreadsheets, landscape orientation often works better than portrait, and "Fit to width" scaling prevents columns from wrapping. If the sheet has frozen header rows, enabling "Repeat frozen rows" in the export options carries those headers to every page, which makes multi-page data much easier to read.
Handling the Output File Size
Excel PDFs with many charts, conditional formatting, or embedded images can be surprisingly large. A workbook that's 2MB as an .xlsx file can produce a 15MB+ PDF if it contains many high-resolution charts. Running the exported PDF through a PDF Compression tool reduces this significantly — charts and embedded graphics compress well, and the text content in cells stays sharp. For PDFs being emailed or uploaded to a portal with a size limit, compression is worth the extra step.
If recipients need to extract the data rather than just view it, consider whether a PDF is actually the right format. A PDF of a spreadsheet is a fixed visual representation — the numbers are there but they can't be formula-linked, filtered, or sorted. For recipients who need to work with the data rather than just read a report, sharing the .xlsx directly or a Google Sheets link serves them better than converting to PDF.