Print Excel Sheets to a PDF

puneet-gogia-excel-champs

- Written by Puneet

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 an install print option called “Microsoft Print to PDF”.

print-to-pdf

Steps to Print to PDF in Excel

  1. Go to the File Tab and click on the “Print” to go to the print section.
  2. From 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 As” dialog box from where you need to select the location to save the PDF file.
print-to-pdf-in-excel

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

It’s there in the Window by Default. But, if you don’t have it, there are a few methods to get it.

Method 1

Open the Run Command in Windows (Window Key + R), 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

It would help if you looked for the “Microsoft Print to PDF” and checkmarked it from here. Then click OK to save the setting.

Important – If it is already check marked, you need to un-check it first and click OK (wait a few seconds). Then, checkmark it back and then click OK.

Method 2

  1. In the second method, open the add printer option in the Windows.
    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 next twice to add the printer.
    image9

You can add “Microsoft Print to PDF” to your Excel application with these steps.

Last Updated: October 03, 2023