Why Convert Excel to PDF?
Saving an Excel sheet as a PDF creates a fixed‑layout document that looks the same on any device, protects formulas from editing, and is ideal for sharing, printing, or archiving. PDF files are universally viewable, smaller in size, and can be secured with passwords.
- Why Convert Excel to PDF?
- Built‑In Methods by Microsoft Office Version
- Excel 2019, 2016, 2013, and Office 365 (Windows)
- Excel for Mac (2016, 2019, Office 365)
- Excel Online (Browser)
- Customizing the PDF Output
- Free Third‑Party Alternatives
- Common Issues and How to Fix Them
- Cut‑off Columns or Rows
- Missing Gridlines or Formatting
- Large File Size
- Automation: Saving Multiple Sheets as PDFs
- Best Practices for Sharing PDF Versions of Excel Data
Built‑In Methods by Microsoft Office Version
Excel 2019, 2016, 2013, and Office 365 (Windows)
1. Open the workbook and select the worksheet you want to export.2. Click File → Export → Create PDF/XPS Document.3. In the dialog, choose a destination folder, name the file, and set Save as type: PDF.4. Under Options, select the range (Entire workbook, Active sheet, or Selection) and whether to publish Document properties.5. Click Publish. The PDF is created instantly.
Excel for Mac (2016, 2019, Office 365)
1. Open the sheet you need.2. Choose File → Save As.3. In the format dropdown, select PDF.4. Click Export. Mac also offers File → Print → PDF → Save as PDF as an alternative.
Excel Online (Browser)
Excel Online does not include a direct PDF export. Use one of these work‑arounds:
- Print to PDF: File → Print → Save as PDF in the browser dialog.
- Download the file, open it in desktop Excel, then follow the Windows/Mac steps.
Customizing the PDF Output
Before exporting, you can control what appears in the PDF:
- Page Layout → Size & Orientation: Choose A4, Letter, Landscape, etc.
- Print Area: Define a specific range (Page Layout → Print Area → Set Print Area).
- Margins & Scaling: Fit sheet on one page or adjust scaling under Page Setup.
- Headers & Footers: Add page numbers, file name, or custom text via Insert → Header & Footer.
Free Third‑Party Alternatives
If you lack a licensed copy of Excel, these tools can convert .xlsx files to PDF without installing Microsoft Office:
| Tool | Verified Detail | Source Type |
|---|---|---|
| LibreOffice Calc | Export → Export as PDF (preserves formatting) | Open‑source documentation |
| Google Sheets | File → Download → PDF document (.pdf) | Google Help Center |
| Smallpdf (online) | Drag‑and‑drop .xlsx, get PDF in seconds | Service website |
Common Issues and How to Fix Them
Cut‑off Columns or Rows
Often caused by print area settings. Reset the print area (Page Layout → Print Area → Clear) and then set it again to include all needed cells.
Missing Gridlines or Formatting
In the Options dialog, ensure Publish what: Document is selected and check Include document properties. Also, verify that Print Gridlines is enabled if you want them visible.
Large File Size
PDF size can balloon if the sheet contains high‑resolution images. Reduce image dimensions or compress them via File → Save As → PDF → Optimize for: Minimum size.
Automation: Saving Multiple Sheets as PDFs
For power users, VBA macros or Power Automate flows can batch‑export sheets:
- VBA Example: Use ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Temp\MySheet.pdf" inside a loop to process each worksheet.
- Power Automate: Trigger on new Excel file in OneDrive, then use the Convert file (Preview) action to produce a PDF.
Best Practices for Sharing PDF Versions of Excel Data
Once you have the PDF, consider these steps to keep the information secure and accessible:
- Password protection: In Adobe Acrobat or free tools like PDF24, set a password to restrict editing.
- File naming convention: Include date and version, e.g., SalesReport_2024Q2_v2.pdf.
- Accessibility: Add document tags for screen readers via Acrobat's Make Accessible wizard.