30 Advanced Excel Tips for 2026

Excel Champs / Excel Basics / How to Print Excel Sheets to a PDF (Quick Method)
By Puneet Gogia (Microsoft MVP)

How to Print Excel Sheets to a PDF (Quick Method)

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

Let’s say you want your Excel sheet as a PDF instead of printing on paper. Well, in Excel, there’s an option for this. When you are using Excel on Windows, there’s already a built-in printer called “Microsoft Print to PDF”.

print-to-pdf

Steps to Print to PDF in Excel

  1. Go to the File tab and click on “Print” to go to the print section (or press Ctrl + P).
  2. From the Printer drop-down, select “Microsoft Print to PDF”.
  3. After that, click on the “Print” button to send the print request.
  4. In the end, it opens a “Save Print Output As” dialog box, where you need to select the location and the name to save the PDF file.

Before you click Print, use the first option under Settings to choose what goes into the PDF: Print Active Sheets, Print Entire Workbook or Print Selection.

print-to-pdf-in-excel

Save as PDF without a PDF Printer

You don’t need a PDF printer at all, as Excel can save a PDF on its own. This also keeps the links in your sheet working in the PDF.

  1. First of all, go to File ➜ Export ➜ Create PDF/XPS Document and click Create PDF/XPS (or go to File ➜ Save As and pick PDF in the file type list).
  2. After that, click Options to choose the Selection, the Active sheet(s) or the Entire workbook, and to ignore print areas if you want.
  3. In the end, select the location, type a name and click Publish.

On a Mac, go to File ➜ Save As and select PDF in the File Format list, or go to File ➜ Print and click PDF at the bottom.

And if you want to do it with a macro, use the ExportAsFixedFormat method. The following code saves the active sheet as a PDF in the same folder as the workbook (the workbook needs to be saved first):

Sub save_sheet_as_pdf()
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=ThisWorkbook.Path & "\" & ActiveSheet.Name & ".pdf", _
OpenAfterPublish:=True
End Sub

What If I Don’t Have “Microsoft Print to PDF” in the List of Printers

It’s there in Windows 10 and 11 by default. But if you don’t have it, there are a few methods to get it.

Method 1

Open the Run dialog box in Windows (Windows key + R), and type “optionalfeatures” in it, or copy-paste it.

run-command-in-windows

After that, click OK to open the Windows Features dialog box, where you have a list of features to select from.

windows-features-dialog-box

Now, look for “Microsoft Print to PDF” and tick its checkbox. Then click OK to save the setting.

Important – If it is already ticked, you need to untick it first and click OK (wait a few seconds). Then, tick it again and click OK.

Method 2

  1. In the second method, open the Add a printer option in Windows (Settings ➜ Printers & scanners).
    image5
  2. After that, click on the “Add manually” option to add a printer manually.
    image6
  3. Next, in the Add Printer dialog box, select the last option, “Add a local printer or network printer with manual settings”, and click “Next”.
    image7
  4. Now, click on “Use an existing port” and select “FILE: (Print to File)” from the drop-down menu and click “Next”.
    image8
  5. From here, select Microsoft and then “Microsoft Print to PDF” and then click Next twice to add the printer.
    image9

You can add “Microsoft Print to PDF” back to Windows with these steps, and then it shows in Excel’s printer list.

Frequently Asked Questions

Why is my PDF split across many pages?

The PDF follows the page setup of the sheet. Before you create it, choose Fit Sheet on One Page (or Fit All Columns on One Page) under Settings on the Print page, and pick the orientation.

How do I save the whole workbook as one PDF?

On the Print page, select Print Entire Workbook before you print to PDF, or in the Save As PDF Options, select Entire workbook.

They work when you use Save As or Export to create the PDF. When you use Microsoft Print to PDF, the PDF is like a printed page, and the links don’t work.

Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel

Leave a Comment