Save table as PDF with Create PDF/XPS feature

Save table as PDF with Kutools for Excel

This method will apply the Create PDF/XPS feature to save a table as a PDF file in Excel. Please do as follows:

1. Select the table you will export as a PDF file, and click File > Export > Create PDF/XPS Document > Create PDF/XPS in Excel 2013/2016. See screenshot:

Note: If you are using Excel 2010, please select the table, and click File > Save & Send > Create PDF/XPS Document > Send as PDF.

2. In the Publish as PDF or XPS dialog box, please (1) select the destination folder you will save the PDF file into; (2) type a name for the PDF file in the File name box; and (3) click the Options button. See screenshot:

3. In the Options dialog box, please check the Selection option in the Publish what section, and click the OK button. See screenshot:

4. Click the Publish button in the Publish as PDF or XPS dialog box.

Now the selected table is saved as a PDF file.

If you have Kutools for Excel installed, you can also apply its Export Range to File feature to save a table as a PDF file in Excel. Please do as follows:

1. Select the table you will save as a PDF file, and click Enterprise > Import/Export > Export Range to File. See screenshot:

2. In the Export Range to File dialog box, please (1) check the PDF option in the File format section; (2) click the Browse button  to select the destination folder you will save the PDF file into; and then (3) click the Ok button. See screenshot:

3. In the second Export Range to File dialog box, please type a name for the PDF file, and click the Ok button. See screenshot:

Now the selected table is exported and saved as an individual PDF file.

Save selection or entire workbook as PDF in Excel

Export/save selection, active sheet or multiple sheets to CSV files in Excel