How to Save Excel as PDF

To save an Excel document as a PDF file make use of a virtual printer such as the Universal Document Converter. Virtual printer means that the document sent for printing is not actually printed out on a sheet of paper, but is sent to the specified folder. Plus, the document will be converted into a desired format, i.e. from Excel to PDF.

To simplify the document conversion the Universal Document Converter adds a toolbar with “hot buttons” into the Microsoft Excel main window. Document conversion in this case will be performed with only a couple of clicks: go to toolbar of the Universal Document Converter and press one of the three buttons: Convert to PDF, Convert to JPG or Convert to TIFF.

Saving Excel workbook as a single PDF is a little bit tricky. This video tutorial will show how to solve this quest:

In case you need to insert a sheet or a diagram into a single PDF file page, please do following:

1. Open Page Layout toolbar in Microsoft Excel and click to bottom-right corner of it
2. Select Fit to 1 page wide by 1 tall feature like shown on the screenshot below
3. Click OK and print Excel file in PDF using Universal Document Converter as a printer.

To place a watermark on the document please do the following:

1. Open the document in Microsoft Excel and click Print
2. Select Universal Document Converter printer and click Properties
3. Choose PDF document as an output file format
4. Go to the Watermark menu and select Text label or Picture. Introduce the desired settings.
5. Click OK to start the conversion process of Excel into PDF.

To protect your document from unauthorized access please do following:

1. Open the document in Microsoft Excel and click Print
2. Select Universal Document Converter printer and click Properties
3. Select the File Format in the settings menu and make sure that the output format specified is PDF Document
4. In PDF Standard select Password protected and enter the password like shown on the screenshot below
5. If you need to add more pages to an existing PDF file the password should remain the same. In case the PDF file is not password protected, you should not password protect any other added pages.
6. Click OK and print Excel to PDF using the Universal Document Converter.

To automate the Excel to PDF conversion in batch mode you need three programs: Microsoft Excel, Universal Document Converter and Print Conductor.

1. Start Print Conductor and add your Excel files to the list of files to be processed
2. Select Universal Document Converter from the list of printers and click Change Settings
3. Specify PDF Document as the type of output file in the settings and click OK
4. Press Start to begin converting Excel to PDF in batch mode.

Receiving numerous files from different sources may cause frustration with the company employees. To avoid this problem as well as the waste of time necessary to convert the files into the preferred format use Folder Mill designed to automate the conversion process.

FolderMill will closely monitor all the incoming files and will convert them to another format. There is nothing to be done manually apart from specifying, for instance, that all the files received in the Excel format should be automatically converted to PDF.

The Universal Document Converter package includes a public API and example code for developers to be integrated into their own systems. Automatic deployment will speed up the process if there is a necessity to install the Universal Document Converter onto a large number of workstations.

The kernel of the Universal Document Converter allows software developers use its features into newly developed products. See examples of converting Excel to PDF for different programming languages.

2Printer is the command line utility that can automate printing Excel documents. The command line interface enables you to create batch-files for automating your specific printing needs. This tool may be included in your Windows Task Scheduler to automate printing process on your computer.

2Printer uses public API of Microsoft Excel to print worksheets. It means that in necessity to print the documents saved as XLS or XLSX, you need to have Microsoft Excel on your computer.

2Printer is compatible with any mechanical printers connected to a computer or accessed via the local networks, and also virtual printers like Universal Document Converter. Thank of this, you are able to convert Excel documents to PDF if you select Universal Document Converter as a printer in 2Printer command line.