With a basic understanding of how Microsoft Excel files print, you can easily create the PDF output you need using the PrimoPDF free pdf creator. And by standardizing print settings across sheets, you can convert your entire workbook to a single PDF.
To standardize print settings across multiple worksheets
- From Microsoft Excel, select the first sheet and click File > Page Setup (Page Layout > Page Setup in Excel 2007).
- From the print quality menu, select the desired DPI, and click OK.
- Repeat these steps for each sheet in the workbook.
To print all sheets in a workbook to a single PDF
- Click File > Print, ensure that Entire Workbook is selected under Print What, and then select the PrimoPDF printer.
Also, don’t forget that you can use PrimoPDF’s Append to Existing option to combine multiple workbooks into a single PDF, simply by assigning the same output filename to each conversion.
2 Comments
CAn anyone tell me how to set the folder to which PDF Download saves files? At the moment it just drops stuff on my desktop, which is a serious pain?
A
Hi Andy, the best place to get PDF Download support is over at http://www.pdfdownload.org/forum/
If you’d like to post over there what version of Firefox you’re using, what Operating system, etc we’ll be more than happy to help!