Excel: Save or Print PDFs Correctly

Key insights

• Save As PDF: Use File > Save As and choose PDF to export the active sheet, a selection, or the whole workbook.
  This preserves most formatting and layout without extra software.
• Print to PDF: Choose Print and select "Microsoft Print to PDF" or another PDF printer to create a PDF from the print dialog.
  This method works well when you need print-style output or when Excel Online export fails.
• Print area: Set a print area before exporting to control exactly which cells appear in the PDF.
  Defining the area prevents unwanted columns or rows from being cut off.
• Page setup: Adjust scaling, orientation, margins, and page breaks to fit content neatly on pages.
  Use "Fit Sheet on One Page" or custom scaling to avoid truncated tables.
• Export options: Choose to export the active sheet, selected cells, or the entire workbook and consider PDF/A for long-term archiving.
  Export settings let you include or exclude document properties and metadata.
• Best practices: Preview the PDF, test a sample export, and fix formatting or numeric display before finalizing.
  Excel’s built-in tools handle most needs; use third-party tools only for advanced edits.

Keywords

Excel save as PDF, Excel print to PDF, Excel export to PDF keep formatting, Print Excel without cutting off, Preserve Excel layout when printing, Excel print settings for PDF, Save Excel as PDF with page breaks, Convert Excel to PDF without changing layout