Skip to main content

How to save selection or entire workbook as PDF in Excel?

Author: Kelly Last Modified: 2020-04-29

In many cases, you may only want to save or export selected ranges as PDF, or save the whole workbook but not only current worksheet as PDF. How to deal with it?

Of course, you can copy selected ranges to a new worksheet and save it as PDF file; or save each worksheet separately as PDF files. But here we will show you a tricky way to save selections or entire workbook as one PDF file in Microsoft Excel quickly, and save multiple workbooks in a specified folder to separated PDF files at once.

Save selection or single workbook as PDF with Save as function

Easily save selection as PDF with Kutools for Excel

Save each worksheet as separated PDF file in a workbook at once with Kutools for Excel


Save selection or single workbook as PDF with Save as function

Step 1: Select the ranges that you will save as PDF file.

If you want to save the entire workbook as one PDF file, just skip this step.

Step 2: Click the File > Save as.

Step 3: In the Save As dialog box, select the PDF item from the Save as type: drop down list.

shot-save-pdf-1

Step 4: Click the Options… button at the bottom of Save As dialog box.

shot-save-pdf-2

Step 5: In the Options dialog box, check the Selection option or Entire workbook option according to your needs.

shot-save-pdf-3

Step 6: Click OK to dismiss the dialog boxes.

Then the selected range or the entire workbook is saved as a single PDF file.


Easily save selection as PDF with Kutools for Excel

This section will introduce the Export Range to File utility of Kutools for Excel, it can help you save a selected range as PDF file easily. Please do as follows.

Before applying Kutools for Excel, please download and install it firstly.

1. Select the range you want to save as PDF file, and then click Kutools Plus> Import / Export > Export Range to File. See screenshot:

2. In the Export Range to File dialog box, you need to:

A: Select PDF option in the File format section;

B: If you want to keep the formatting, row heights and column widths of selection, please check the Preserve formatting / row heights / column widths options in the Workbook options section;

C: Click the button to select a folder to save the PDF file;

D: Click the OK button.

Note: If you want to directly open the PDF file after exporting, please check the Open the file after exporting box.

3. Now another Export Range to File dialog box pops up, type a name for the PDF file in the box, then click the OK button.

Now the selection is successfully saved as PDF file.

  If you want to have a free trial (30-day) of this utility, please click to download it, and then go to apply the operation according above steps.


Save each worksheet as separated PDF file in a workbook at once with Kutools for Excel

You can save each worksheet or specific worksheet in a workbook as separated PDF file with the Split Workbook utility.

Before applying Kutools for Excel, please download and install it firstly.

1. Click Kutools Plus > Workbook > Split Workbook. See screenshot:

2. In the Split Worksheet dialog box, please check the worksheets you need to save as individual PDF files in the Worksheet name box, in the Options section, check the Save as type box, and select PDF (*.pfd) from the drop-down list, and then click the Split button. In the popping up Browse for Folder dialog box, select a folder for saving these pdf files, and finally click the OK button. See screenshot:

Then all selected worksheets are saved as individual PDF file immediately.

  If you want to have a free trial (30-day) of this utility, please click to download it, and then go to apply the operation according above steps.


Demo: Save selection or each worksheet as PDF with Kutools for Excel


Related articles:

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Description


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (31)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
How do I email.
This comment was minimized by the moderator on the site
Thank you!!
This comment was minimized by the moderator on the site
Thanks. Great information.
This comment was minimized by the moderator on the site
This is the longest solution I've ever seen for this. If you simply wanna include all the sheets from your .xlsx file, just hold down CTRL, select the first one, add a hold down shift and select the last one in the range, they will look selected (a little whiter). After your selection, you can depress the keys and go File > Save as... and select .pdf from the drop-down menu.
This comment was minimized by the moderator on the site
Thank you sooooooo much! This should just be at the top of this page.
This comment was minimized by the moderator on the site
Glad I read this review! The above article is too long!
This comment was minimized by the moderator on the site
This was very helpful!
This comment was minimized by the moderator on the site
MUCH APPRECIATE - EASY WHEN YOU KNOW HOW!
This comment was minimized by the moderator on the site
Thank you! Each step is very well depicted and the instructions are informative and clear to read.
This comment was minimized by the moderator on the site
Many thanks it was helpful
This comment was minimized by the moderator on the site
Thanks so much! I looked everywhere. This helped a lot. Thanks for sharing.
This comment was minimized by the moderator on the site
Thank you. This helps a lot.
There are no comments posted here yet
Load More
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations