Converting Excel Spreadsheets to PDF

← Back to Blog

Why Convert Excel to PDF?

Converting Excel spreadsheets to PDF serves several practical purposes. A PDF presents data in a fixed layout that looks identical on any device and in any viewer, without the recipient needing Microsoft Excel installed. It eliminates the risk of recipients accidentally or intentionally altering figures — important when sharing financial reports, proposals, or formal data submissions. It also hides underlying formulas and cell references, which may be commercially sensitive. For archiving purposes, a PDF snapshot captures the data as it was at a specific point in time, independent of any future changes to the source workbook.

Method 1: Save As PDF Directly from Excel

The simplest approach for most users is Excel's built-in PDF export:

1. In Excel, go to File > Save As (or File > Export > Create PDF/XPS in newer versions).
2. Choose PDF (*.pdf) from the file type dropdown.
3. Before saving, click Options to control what is exported: the active sheet, the entire workbook, or a selected range.
4. Choose Standard quality for most purposes; Minimum size reduces file size at the cost of image quality.
5. Click Publish or Save to create the PDF.

This method is fast and requires no additional software. However, it relies entirely on Excel's own PDF rendering, which may not handle complex formatting as precisely as a dedicated PDF tool.

Method 2: Print to Adobe PDF Printer

If Adobe Acrobat Pro is installed, an Adobe PDF virtual printer is available in Excel's print dialog. This method gives you access to Adobe PDF Settings (job options) for finer control over colour profiles, compression, and font embedding. Select File > Print, choose Adobe PDF as the printer, and click Print. You will be prompted to name and save the output file.

Method 3: Create from File in Acrobat

In Adobe Acrobat Pro, use Tools > Create PDF > Single File, browse to the Excel workbook, and click Create. Acrobat will open Excel in the background, convert the file, and open the resulting PDF. This method preserves Excel hyperlinks as active PDF links in the output document.

Controlling Page Breaks and Print Areas

Large spreadsheets often spread across many PDF pages in unexpected ways. Controlling the print area and page breaks before conversion is essential for a clean output.

• Set a print area: Select the cells you want to include, then go to Page Layout > Print Area > Set Print Area. Only this range will appear in the PDF.
• Insert manual page breaks: In Page Break Preview (View menu), drag the blue dashed lines to set where pages break. This gives you precise control over what appears on each page.
• Fit to page: In Page Layout > Scale to Fit, set the width to 1 page to force all columns to fit on a single page width. Adjust height separately as needed.

Fitting Content to Page Width

A common problem when converting spreadsheets to PDF is columns being cut off or running onto a second page. To address this, set the scaling option to fit to a specific number of pages wide. In the Print dialog, use the Fit Sheet on One Page option, or select Fit All Columns on One Page if rows are acceptable across multiple pages. Note that aggressive scaling makes text very small — check the preview before committing.

Gridlines and Row/Column Headers

By default, Excel does not print gridlines or row/column headers (the A, B, C column letters and 1, 2, 3 row numbers). To include them:

• Go to Page Layout and tick Print under the Gridlines group to include cell borders.
• Tick Print under Headings to include row and column labels.

Gridlines can be useful when sharing data tables where the visual grid aids readability, but are typically omitted for polished reports where table borders are already styled.

Multi-Sheet Workbooks: Combined vs. Separate PDFs

If your workbook contains multiple sheets and you want them all in one PDF, select all sheet tabs (right-click a tab and choose Select All Sheets) before exporting. In the Save As dialog, the Options setting should be set to Entire Workbook. Each sheet will become a separate section of the combined PDF.

To export each sheet as a separate PDF, you can step through the sheets individually and export each one, or use a macro to automate the process across all sheets.

Preserving Hyperlinks and Embedding Fonts

When using Save As PDF in Excel, hyperlinks in cells are generally preserved as active links in the PDF output. When printing via the Adobe PDF printer, hyperlinks may not be retained unless you use Acrobat's PDFMaker add-in (the Acrobat tab in the Excel ribbon), which is designed to maintain document structure including links, bookmarks, and tagged content.

Font embedding is handled automatically by Excel's PDF export and by the Adobe PDF printer — you do not need to manually embed fonts. If you are distributing the PDF to clients or archiving it for compliance, verifying font embedding via Acrobat's File > Properties > Fonts tab is good practice.