How to Save Selected Range As PDF From Excel

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:

Social media:

[SimonLangridge-nogu]

Thank you, precise and concise, above all showed options for same result.

[imwatchingyourchannel]

thanks for your help, i spend 3 days searching and now i found the right way 😊😊😊😊

[Odiavloggerjyoti]

You are now like a god to me you saved me from a nightmare

[AbubakarrJr]

You just saved me from a very big headache 😅😂 Thanks

[christopherhalomoan]

makasi bang tutorialnya aku udah like dan sabrek yaaa ditunggu konten selanjutnya yang bermanfaat

[mattburton]

the print way is the best way, especially on mac

[harshiljadav]

after saving, all data is showing without table/ lines

[kirantechnophile]

how to convert with grid lines that is col and row lines? In my PC it only comes with plain text