• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • Mac
  • iOS
  • Android
  • Office
Home » Excel » How to Print to PDF or Save As PDF in Microsoft Excel

How to Print to PDF or Save As PDF in Microsoft Excel

By: Waseem Patwegar

You can convert any Excel File or Spreadsheet to PDF Format using “Save As PDF” or “Print to PDF” features as available in Microsoft Excel. You will find below the steps to Print to PDF or Save As PDF in Microsoft Excel.

Print to PDF or Save As PDF in Microsoft Excel

Print to PDF and Save As PDF in Microsoft Excel

With Windows 10 featuring in-built support for PDF (Printable Document Format), saving or printing any Excel Spreadsheet to PDF format is easy.

While both “Print to PDF” and “Save As PDF” basically convert an Excel File to PDF format, the end product produced by the two methods are different.

When you use Print to PDF in Microsoft Excel, the resulting PDF File will be stripped of all its Metadata (Links, Author info, Bookmarks, etc.) and it will only contain information as available on a printed File.

In comparison, when you use Save As PDF in Microsoft Excel, the resulting PDF File will contain all the Metadata and almost the same information as available in the original document.

How to Print to PDF in Microsoft Excel

Follow the steps below to use Print to PDF in Microsoft Excel.

1. Open the Excel File that you want to Print to PDF.

2. Once the File is open, click on the File tab located in the top menu bar to open the File menu.

File Tab in Microsoft Excel

3. In the drop-down File menu, click on the Print option in the left pane. In the right-pane, make sure that PDF Printer (Microsoft Print to PDF) is available and adjust page size, orientation and margins as required.

PDF Printer Settings Option in Microsoft Excel

Note: If Microsoft Print to PDF is not available, you will have to make the PDF Printer ready using steps as provided in the next section.

4. Once you are happy with the print settings, scroll up a bit and click on the Print box.

Print to PDF option in Microsoft Excel

5. On the next screen, type a Name for your file > choose the Location where you want to save the resulting PDF file and click on the Save button.

Save Printed File As PDF in Microsoft Excel

Note: Make sure “Save as type” is set to .pdf before clicking on the Save button.

Once the PDF Print File is saved, you will be able to send the File for printing or share it electronically with anyone.

As mentioned above, the PDF File produced by using Print to PDF feature in Microsoft Excel will not contain Links and other Metadata associated with the original Excel File.

What to Do if Microsoft Print to PDF is Not Available

If you had previously printed to an actual printer, Microsoft PDF Printer may not be available when to try to Print to PDF in Microsoft Excel.

In such a case, you will have to make Microsoft PDF Printer available and ready, before being able to Print to PDF.

If “Microsoft Print to PDF” is not available, click on the current available printer and choose Microsoft Print to PDF in the menu that appears.

Switch to PDF Printer in Microsoft Excel

After this, you will be able to Print to PDF any Microsoft Excel File by clicking on the Print box as shown in step 3 above.

Save As PDF in Microsoft Excel

Another way of converting Microsoft Excel File or Spreadsheet in to PDF format is to use “Save As PDF” feature, as available in Microsoft Excel.

As mentioned above, the resulting saved PDF File will contain almost all the information as available in the original document.

1. Open the Excel File that you want to Print to PDF.

2. Once the File is open, click on the File tab located in the top menu bar.

File Tab in Microsoft Excel

3. From the drop-down menu, click on Save As option in the left pane. In the right-pane, click on Browse.

Save As PDF Option in Microsoft Excel

4. On the next screen, type the Name for your PDF File > select Location for the PDF file and click on Save.

Save Excel File As PDF

This will save the Microsoft Excel File as a PDF File that you can print or share with anyone.

Whether you use Save as PDF or Print to PDF, the resulting file will retain its Fonts, Formatting and Pagination across all devices and platforms.

Related
  • How to Enable Send to Mail Recipient Option in Excel and Word
  • How to Bypass Start Screen in Microsoft Word and Excel

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Show Developer Tab in Excel Ribbon Menu
        Add or Show Developer Tab in Excel Ribbon Menu
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar

Twitter
Facebook



Popular Now

  • How to Reduce Cellular Data Usage on iPhone
  • How to Backup Registry in Windows 11/10
  • How to Check Computer Specs in Windows 10
  • How to Remove Bloatware From Windows 10 PC
  • How to Create Local Account in Windows 11



Gadget Guide

  • Mac vs PC Comparison: Should You Buy Mac or PC
  • Chromebook vs Windows Laptop
  • Kindle E-Reader Comparison | Which Kindle to Buy
  • iPad vs iPad Pro Comparison
  • Advantages of Chromebooks

About | Privacy Policy | Disclosure | Terms | Contact
© Copyright 2022 @Techbout.com · All Rights Reserved