How to save table as PDF in Excel?
You may be familiar with saving a worksheet as an individual PDF file in Excel, but do you know how to save only a table as a PDF file? This article will share two solutions to deal with this problem.
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
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.