DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to Convert Excel Files to PDF in Microsoft Excel?

Convert Excel Files to PDF:

MS Excel is one of the most popular software used worldwide to perform complex mathematical calculations, handle the vast data set, and store the data for prolonged use. Here we come up with a built-in feature in Excel that converts files into PDF. In this tutorial, we are going to learn how to Convert Excel Files to PDF Format.

Save the File As PDF:

  • This method is the most common among Excel user to Save the File as a PDF.
  • To do this, you need to go to the File tab, select Save As , or Save as Copy option.
  • Select the File type as PDF.
  • Click the Save button.

  • We will save your new PDF file in the exact location as the Excel file saved before.
  • If you want to access other ** advanced PDF file options** for the converted file, you can use the Options button in the Save As dialog box.
  • It will open the menu, and you can move the PDF file to the new location.

Export a File As PDF:

  • You can Use Export Option in Excel to ** export a file as a PDF**.
  • To do this, Go to the File tab, select the Export option from the menu.
  • Select the *Create PDF/XPS Document * option.
  • Then, click the Create PDF/XPS button.

  • It will open publish as PDF or XPS dialog box.
  • It is the same as the “Save As” menu, and you can choose the location to publish.

Publish As PDF Quick Access Toolbar Command:

  • You can Add Publish As PDF option ** to Quick Access Toolbar Command**. So that you can easily access this option.
  • To do this, Right-Click on the Quick Access Toolbar command and select Customize Quick Access Toolbar from the menu.
  • It will display the Excel Options Dialog box.
  • Choose Quick Access Toolbar from the list. Then Select All Commands option.
  • Now, Select Publish as PDF or XPS option.
  • Press Add button to add this command to Quick Access Toolbar.
  • Hit the Ok button.

  • Now, you can use this command on the Quick Access Toolbar to Publish the Excel File as a PDF.

E-mail As PDF Attachment Quick Access Toolbar Command:

  • It is one of the attractive options in Excel because it will convert the file as a PDF and then create a new E-mail with this PDF attachment.
  • If you want to E-mail any file as PDF, you can make use of it.
  • To do this, ** Right-click** on the Quick Access Toolbar and select the Customize Quick Access Toolbar option from the list.
  • It will display the ** Excel Options** Dialog Box.
  • Now, Select the Quick Access Toolbar tab from the menu.
  • Select ** All Commands** and then Choose E-Mail as PDF Attachment option.
  • Click the Add button, then hit the Ok button.

  • Now, we will add it to the Quick Access Toolbar. You can easily use this option from the Quick Access Toolbar.

  • When you click this icon, it will create an E-Mail outlook with the subject line of your workbook name.

Bottom Line:

In this tutorial, you can understand the simple ways to Convert Excel Files to PDF in Microsoft Excel 365. Kindly share your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!!

Top comments (0)