How to convert worksheet in to PDF using Excel

If you want to distribute your excel worksheets as read-only document then one of the option is to convert it to PDF. Listed below are the different ways to save or export excel worksheet to PDF in Excel 2016, 2013 & 2010. For this demo, let us take the below example data.

Excel 2013 Sample data

Using Save As

The first option that we are going to see is File –> Save As.

Step 1: Click the File menu, select Save As from the menu list.

File, Save As, Excel 2013

Step 2: In the Save As screen, double click on computer to save the PDF to local folder.

Save As Computer Excel 2013

Step 3: In the Save As dialog box, choose PDF for save as type. After entering suitable name for your file, click the Save button.

Set file type to PDF

This should save the excel worksheet as PDF file.

converted PDF file

Using Export

Another option to convert an excel worksheet to PDF is by using Export feature.

File Export Excel 2013

Step 1: Click the File menu and select Export from the menu list.

image

Step 2: In the Export screen , click the Create PDF/XPS button under Create a PDF/XPS Document. This should display the Publish as PDF or XPS dialog box with Save as type to .PDF

image

Step 3: After entering name for your PDF file, click the Publish button.

You can also try the Change File Type option under Export section to change the File type to using Save as Another File Type.

image

Also See: How to quickly send worksheet as PDF in Excel 2013



Meet the Author

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

0 comments… add one

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.