How to Save Excel as PDF

July 31, 2023731 views

PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work.

Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.

??16.png

Steps to Save Excel as PDF

Step1

When we want multiple tables to convert at the same time, click Add files in the upper left corner to select other files.

Step2

Usually, while setting Export Type, we can choose Common PDF, but if you don't want the file to be modified and copied at will, you can join WPS premium and convert the table to Image PDF.

Step3

Finally, you can set the directory at Save Path, then click the Export to PDF button, and you can check the PDF file.

??17.png

Steps to Save Excel as PDF with WPS

WPS also provides more advanced settings for converting excel to PDF.

Step1

Click Advanced Settings in the Output as PDF dialog box. In the pop-up dialog box of Advanced Settings, we can set the Content and the Permission Settings of PDF.

Step2

At Content, we can choose what to export according to our needs, such as File Information, Comment, and Hyperlink. Here, we check all three options, click the Confirm button, and click Export to PDF. Once you have successfully completed the process, comments and hyperlink information can be found in the converted PDF file.

??18.png

Step3

Besides, we can add a password for the converted PDF. In this case, we can set its specific operation permission, such as  Allow modify, Allow copy, Allow annotate, Unrestricted printing, Low quality printing, Print is forbidden, etc.

??19.png

For example, suppose you do not want the file information to be copied by others. In that case, you can set a password and deselect Allow copy to limit the operation permission.

In addition, we can add an additional open password for the file. Here, enter the password at Open file password.

At this point, click Export, and when opening the PDF file, we need to enter the correct password to open the file.

A correct password is needed if someone wants to copy the contents.

??20.png

Did you get it?

Easily convert WPS Word, Excel, and PowerPoint documents to PDF using free WPS PDF tool. You can also convert documents without for Windows, PC, Mac, Linux, Android, and iOS devices. In WPS Academy, learn how to convert Microsoft Word, Microsoft Excel, and Microsoft PowerPoint documents to PDF.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.