Export Excel to PDF (4 Ways)

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will learn how to export an Excel file to a PDF. This conversion is helpful if you want to share your Excel data in a non-editable manner. You can also do this to store a PDF format of your Excel file.

Exporting an Excel file to PDF is a built-in feature of Microsoft Excel. This feature offers multiple export options to best serve your need. You may choose your required option and export your Excel file to PDF.

export excel to pdf


Download Practice Workbook

You can download the workbook from here and practice yourself.


Export Excel to PDF: 4 Methods

1. Saving Excel as PDF with Multiple Options

  • We will save this Excel file as PDF.

img2- excel dataset to save as PDF

  • Select File.

img3- selecting file

  • Go to Save As >> Browse.

img4- selecting save as and browse options

  • Click on the drop-down icon of Save as type and select PDF.
  • After that, click on Options.

img5- choosing save as options

  • Choose the option according to your need.
  • Click OK.

img6- different saving options

  • Click Save to save the Excel file as PDF.

img7-save file

  • As a result, the Excel file is saved as PDF.

img8- file saved as pdf


Saving Excel as PDF in One Page

  • You can save the Excel file as a one-page PDF.

img9- dataset to save in one page

  • Select File.

img10- selecting the file menu

  • Go to Print >> Page Setup.

img11- opening page setup

  • Select the options as shown in the following image and click OK.

img12- page setup options

  • Now, select Save As >> Browse.

img13- save as and browse options selection

  • Set PDF as the Save as type and click on Save.

img14- pdf option selection

  • Hence, the Excel file will be saved as a one-page PDF.

img15- The Excel file is saved as a one-page PDF


2. Exporting Excel as PDF

  • You can also export an Excel file as PDF.

img16- Excel dataset to be exported as PDF

  • Select File.

img17- selecting File menu

  • Go to Export >> Create PDF/XPS Document >> Create PDF/XPS.

img18- selecting the export option

  • Finally, select Publish to export the Excel file as a PDF one.

img19- selecting Publish option

  • Hence, the Excel file is exported as a PDF file.

img20- exported as PDF


3. Publishing Excel as PDF

  • We can publish an Excel file as PDF.

img21- dataset to publish as PDF

  • Select File.

img22- selecting file option

  • Click Options.

img23- click options

  • Follow the process as shown in the image below to add Publish as PDF or XPS in the Quick Access Toolbar.

img24- adding publishing option

  • Now, click on the icon shown in the following image to publish the Excel file as PDF.

Img25- publish option selection 

  • Finally, click on Publish.

img25.1- clicking to Publish

  • As a result, we can see that, the Excel file is published as a PDF.

img26- published as PDF


4. Emailing Excel as PDF Attachment

  • You can email an Excel file as a PDF Attachment.

img27- dataset to email as PDF

  • Select File.

img28- selecting File

  • Click on Options.

img29- click options

  • Follow the procedure as shown in the image below to add E-mail as PDF Attachment to Quick Access Toolbar.

img30- adding Email option to quick access toolbar

  • Now, click on the icon shown in the following image to email the Excel file as a PDF Attachment.

img31- click here to email the Excel file as a PDF attachment

  • As a result, we can see that, the Excel file is attached in an email as a PDF attachment.

img32- the Excel file is attached as PDF


Things to Remember

While working on exporting an Excel file to PDF, you should remember some facts in mind.

  • Choose the export option according to your need.
  • Check the Excel file properly before exporting it as PDF.
  • Perform page setup to give a custom look to the PDF.

Frequently Asked Questions

1. What is the shortcut key for exporting to PDF in Excel?

Alt + F followed by Alt + E is the required shortcut key.

2. Where are exported files saved?

Exported files are saved in your directed file directory.

3. How do I Export an Excel file to text?

You can export an Excel file to your required file format using the Save As feature of Excel.


Conclusion

We have demonstrated the methods of exporting an Excel file to a PDF in this article. You will be able to perform this exportation all by yourself if you have followed this article thoroughly. If you face any issues doing so, please let us know in the comment section. Team Exceldemy will be glad to solve your problem. Have a good day!


Export Excel to PDF: Knowledge Hub

<< Go Back to Export Data from Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Hadi Ul Bashar
Hadi Ul Bashar

Hadi Ul Bashar holds a BSc degree in Biomedical Engineering from Bangladesh University of Engineering and Technology.  In January 2023, Bashar joined SOFTEKO as an Excel and VBA content developer. Since then, he has authored over 50 articles. He was engaged in two specialized training programs focused on VBA and Chart & Dashboard designing in Excel. Currently he is creating video content on Excel and VBA and has created over 70 videos. Reading books and traveling are his... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo