How to convert Excel to PDF in MS Office
PDF is very popular and versatile format that is generally used for distribution of documents and printing.
Using PDF, it is easy to print a long work book with multiple sheets. You can give a single print command to print a long document. Further it is not necessary to have MS office installed to access PDF document.
Another benefit of using PDF file for distribution is that formulas, macros and formatting can be restrict to share for copyright and security reasons.
From MS Office version 2007 and higher, printing or save as PDF is available itself in the MS Excel. You can easily convert excel to PDF inside MS office 2010, 2013, 2019 and MS Office 365.
Table of Contents
How to convert Excel to PDF in MS Office, step by step guide
- Open the excel file, click on save as button
- In the drop-down list, select PDF from available file format options
- Now choose your options as “standard publishing” or “minimum size” from the dialogue shown below
- If you choose standard publishing, PDF size will be higher in size. Size of PDF will also depend on the graphics, chart, tables inside the Excel file. This option is good if you are going for printing original quality of documents.
- Second option “minimise size” will make a very compact and low size of PDF file that is good for emailing and uploading online purposes.
6. If you want to convert whole work book including its all worksheets into a single PDF file follow the below steps:
- Click over options
- Now select different options available e.g. page range, selection, active sheet or entire workbook
Other tweaks for save as PDF option in MS Excel
You can also select save as PDF directly using export tab in File.
- Click export tab under File menu
- Now click on “create PDF/XPS”
How to add save as button in the Quick access tool bar of MS Excel
You can also create an icon on quick access tool bar for faster access of “save as PDF”.
- Click on File -> Options -> Quick access tool bar
- Now from drop down select as all commands in place of popular commands
- In the list shown below, scroll down to reach “save as other formats” with small arrow (see screen shot below).
- Now save as button will be added to quick access tool bar of MS Excel.
When you click over this button will see save as options as described above. If you click on the small arrow near to this button you can find option to save as PDF.
Other methods on How to convert excel to PDF
Using Windows 10 inbuilt PDF Printer
You can also convert any file to PDF Using Windows 10 inbuilt “Microsoft Print to PDF” option. Reach this option by selecting the printers in Print dialog under File Tab menu, or using Ctrl+P keys combinations. From the available printers, select the Microsoft PDF to Print Printer.
In this option you can select various options like print current sheet or entire work book or selection.
If this option is not available in your PC, you can enable this using Programs and features inside control panel.
Click control panel -> Select Programs -> Now click over “turn windows feature on or off”.
From the available options search for Microsoft PDF to print, click over the check box to enable this feature and click Ok.
Using Third Party PDF printers
You can also convert any file to PDF using some third-party PDF converters like doPDF, Nova PDF etc.
Further if you have installed Foxit PDF reader or Adobe PDF reader, their PDF printer will also available on the available list of printers in Windows.
You May Like to See: How to convert PDF to word using MS Word 2016 and One Drive
Convert Excel to PDF using online tools and websites
Many online tools and website also convert Excel to PDF or vice versa. For example, zamzar.com, smallpdf.com, ilovepdf.com.
Upload excel file in their online platform, and download the converted PDF file.
Convert Excel to PDF using Onedrive and Google Drive
Using Google Drive and Onedrive, you can also convert excel to PDF.
Steps for converting Excel to PDF using Google Drive
- Upload the file into Google Drive
- Open the file using Google Sheet
- In the file tab, click over download button, select download as PDF option
- In the opened dialog, select current sheet or entire workbook as per your need.
Steps using OneDrive
- Upload the file into Microsoft OneDrive
- Open the file inside Onedrive using Excel editor.
From the print option inside file menu, use print command to convert PDF file using Windows printers like Microsoft PDF to print.
Save as PDF or download as PDF option is not available for while in online excel editor of OneDrive. However same is available for online editor of Word and Power Point of Onedrive.
Final Words
Hope using above mentioned methods we are able to explain you, how to convert excel to PDF. Using these methods you can convert not only single worksheet but can also convert whole workbook into a single PDF file.