This post looks at Microsoft Excel to PDF conversion, and how, by converting files from within Microsoft Excel to PDF, you can create more intelligent PDF files using the Nitro Pro add-in. We’ll look at how it’s done in Microsoft Office 2007, but you can do pretty much everything in older versions of Office.
Excel to PDF conversion settings
While the options in the Create PDF and Secure PDF groups contain the creation tasks, the Settings group is where you go to set how your PDF files should be converted. The really handy thing to keep in mind is that the settings you choose here are remembered, so if you like to perform the same conversions over and over, once you’ve chosen them here, all you’ll need do is click on one of the Create and/or Secure buttons to convert the Excel (XLS) file.
- Print all sheets. Converts all the sheets in your Excel file into the one complete PDF.
- Open PDF after creation. (This hardly needs explaining, but here goes.) Once converted to PDF, it is opened in your default PDF viewer.
- Prompt for filename. This lets you specify the file name and destination by prompting you during the creation process.
- Add Bookmarks to PDF. This automatically adds basic navigation to your PDF file by grabbing the name of each sheet and turning it into an active bookmark.
- Attach source file. This attaches your Microsoft Excel file inside your PDF. This reduces the chance of misplacing the source file and makes updating the source file much more easy.
- Convert document summary. This option converts the details listed in your document properties in Excel, including document title, author, subject and keywords.
If you want to read about full Nitro Pro creation functionality, check out the create PDF files feature overview page on the Nitro site.
