PDF Converter

How to Save Selected Range as PDF From Excel
Suppose you have a workbook consists of several worksheets and you need to convert it into PDF. But there are confidential data also that you don’t want in the PDF. This is the situation where you need to save only selected range as pdf. In this tutorial we’ll learn to export selected cells in excel to pdf. There are four ways you can save selected cells in excel as pdf and they are as follows:

Procedure 1:
Step 1: Click on “File” Menu
Step 2: Click on “Save As”
Step 3: Select the save as location.
Step 4: Select PDF from the save as type dropdown
Step 5: Now click on “Options” and Select “Selection”
Step 6: Click Ok and done.
Your entire selection is converted as PDF. Now let’s do the same thing differently.

Procedure 2:
Step 1: Click on “File” Menu
Step 2: Click on “Export”
Step 3: Select “Create PDF/XPS Document”.
Step 4: Click on “Create PDF/XPS”
Step 5: Now click on “Options” and Select “Selection”
Step 6: Click Ok and done.
You just saved selected cells in excel as PDF. Now let’s move to the third way to convert excel to pdf. We are going to use the same technique to convert excel to pdf but in a different way.

Procedure 3:
Step 1: Click on icon from the Quick Access Toolbar and Select “More Commands”
Step 2: From the Dropdown Select “All Commands”
Step 3: From the list select “Publish as PDF or XPS” and Click Add.
Step 4: Click ok and click on “Publish as PDF or XPS” from the QAT
Step 5: Now click on “Options” and Select “Selection”
Step 6: Click Ok and done.
From the next time just follow the step 4, 5 and 6. It’ll do the job. Now let’s move to the last way to save excel as pdf.

Procedure 4:
Step 1: Click on “File” Menu
Step 2: Click on “Print”
Step 3: From the Printer option select your default PDF reader.
Step 4: From the settings option Select “Print Selection”
Step 5: Now click on “Print” and select where you need to save the pdf
Step 6: Click Ok and done.
These were the four ways on how to convert selected range into pdf file from excel. This will convert excel to pdf without losing formatting.
#Convet #Workbook #PDF

Thanks for watching.
————————————————————————————————————-
Support the channel with as low as $5

————————————————————————————————————-
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:
Advance Excel Tutorial:
Excel Tutorial for Beginners:
Excel Case:
Combine Workbook & Worksheets:
All About Comments in Excel:
Excel VBA Programming Course:

Social media:
Facebook:
Twitter:
Blogger:
Tumblr:
Instagram:
Hubpages:
Quora: …(read more)

Convert Word 2 PDF: Word to PDF Converter

Convert PowerPoint 2 PDF: PPT to PDF Converter

Convert Excel 2 PDF: Excel to PDF Converter

Convert an Image 2 PDF: Image to PDF Converter

Convert HTML 2 PDF: HTML to PDF Converter

More Tools: PDF Converter