How Do I Save Workbook in PDF?

Saving Workbook in PDF (Portable Document Format)

PDF is a fixed-layout electronic file format that preserves document formatting and enables file sharing. The PDF ensures that when the file is viewed online or printed, it retains exactly the format that you intended, and that data in the file cannot easily be changed. The PDF is also useful for documents that will be reproduced by using commercial printing methods.

To view a PDF file, you must have a Adobe Acrobat Reader or other PDF reader installed on your computer. When a workbook is saved as PDF, you cannot use your MS Excel that created it to make changes directly to the file. You must make changes to the original workbook in the MS Office release program in which you created it and save the file as PDF again. You can save as a PDF from a Microsoft Office Excel 2007 only after you install an add-in which you will get from this website: microsoft.com and follow the instructions on that page to istall the add-in. However, the download is available to only customers running genuine Microsoft Office software.

Now you can take the following steps to save a workbook in PDF:

METHOD 1:

1. Open the Workbook you want to convert to PDF, click the Microsoft Office button and click Print.
2. From the Printer Name box select the PDF printer from the list of available printers and click Ok.
3. The PDF window appears. Enter a name and location for the PDF file. You can also set other PDF options at this time.
4. Click Create PDF.

METHOD 2:

1. Click the Microsoft Office Button or Click File on the Menu Bar, point to the arrow next to Save As or Click Save As, and then click PDF.
2. In the File Name list, type or select a name for the workbook.
3. In the Save as type list, click PDF.
4. If you want to open the file immediately after saving it, select the Open file after publishing check box. This check box is available only if you have a PDF reader installed on your computer.
5. Next to Optimize for, do one of the following, depending on whether file size or print quality is more important to you:
1. If the workbook requires high print quality, click Standard (publishing online and printing).
2. If the print quality is less important than file size, click Minimum size (publishing online).
6. Click Publish.

 

METHOD 3:

1. Click File on the menu bar, click Save As.
2. In the File Name list, type or select a name for the workbook.
3. In the Save as type list, click PDF.
4. If you want to open the file immediately after saving it, select the Open file after publishing check box. This check box is available only if you have a PDF reader installed on your computer.
5. Click Save.