Saving a 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 https://www.patreon.com/excel10tutorial ------------------------------------------------------------------------------------------------------------- Please subscribe to #excel10tutorial https://goo.gl/uL8fqQ Here goes the most recent video of the channel: https://bit.ly/2UngIwS Playlists: Advance Excel Tutorial: https://goo.gl/ExYy7v Excel Tutorial for Beginners: https://goo.gl/UDrDcA Excel Case: https://goo.gl/xiP3tv Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB All About Comments in Excel: https://bit.ly/excelcomments Excel VBA Programming Course: http://bit.ly/excelvbacourse Social media: Facebook: https://facebook.com/excel10tutorial Twitter: https://twitter.com/excel10tutorial Blogger: https://excel10tutorial.blogspot.com Tumblr: https://excel10tutorial.tumblr.com Instagram: https://www.instagram.com/excel_10_tutorial Hubpages: https://hubpages.com/@excel10tutorial Quora: https://bit.ly/3bxB8JG *Become a member and enjoy exclusive perks while supporting the channel you love!* https://www.youtube.com/@Excel10tutorial/join