Buy Now

novaPDF Professional
$62.44 $49.95

novaPDF Standard
$53.27 $39.95

novaPDF Lite
$24.94 $19.95

Awards & Reviews

  • 1_ico
  • 2_ico
  • 3_ico
  • 4_ico

Lockergnome feature

novaPDF is really neat

"novaPDF – Print To PDF Without Breaking The Bank. After downloading and installing the program (which takes all of one minute) you’re ready to print to a PDF. Any program that can print via the standard Windows printer interface can print to PDF (i.e. convert a file to PDF), including text, Word, Excel, […] , novaPDF will convert your files into PDF format without making your wallet cry."

Editor’s Review

This application is great

"[...] Pluses: novaPDF supports multiple profiles. This means that all your settings can be easily saved or loaded. Another great feature is the program’s ability to put bookmarks into the PDF document it creates. Drawbacks/flaws: [none] In conclusion: This application is great for generating PDF documents out of any type of printable data."

Indezine Review

Provides a good balance

"[...] novaPDF provides a good balance between price and performance -- it's a very usable option between free and highly priced PDF creators so that you can provide PDF output capabilities to a large number of users at a reasonable cost."

AC Review

Extremely easy to use

"[...]I highly recommend NovaPDF as a great and very simple way to create standard PDF documents that are fully compatible with Adobe Acrobat Reader. Nova PDF creator is an extremely easy to use and simple PDF creator"

Latest News

April 12, 2010

novaPDF 7.1 was released.

Changes in version 7.1:
  • Added visibility layers for watermarks
  • Added Document Creator option
  • Added Page Scaling options
  • Added option to remove PDF after emailing
  • Added Lithuanian language

You can download version 7 here: Download novaPDF 7.1

Stay Updated

To join, simply enter your email address below and click on Subscribe.

About Us

Softland, the company that develops novaPDF, achieved the Microsoft Certified Partner status with an ISV/Software Solutions Competency. Microsoft Certified Partner
Share
Add comment
Votes: 28
Comments: 22
If you have multiple individual sheets within your Excel workbook, when you try to create a PDF and choose to print the Entire Workbook, each sheet will be saved as a different PDF file. This happens because one (or multiple) sheets in your workbook has a different dpi setting for printing. Because of this, Excel assumes that each individual sheet has to be sent for printing separately, so it will send it in the same way to the PDF printer which will prompt to create a PDF from each sheet.

In order to have all the individual sheets printed within a single PDF file (not multiple PDFs) you need to set the same DPI printing value for all of them. 

In order to set the DPI value for each individual page, you have to follow these steps:
  1. Open the Excel workbook
  2. Select the sheet you want to set the DPI for
  3. In Microsoft Excel 2007 go to Page Layout and click on the expand button for the Page Setup dialog (for Microsoft Excel 2003 or earlier go to File->Page Setup)
  4. In the Print Quality section enter the DPI value that you want to have for your document (note that this is the DPI value you will have to set for each individual sheet too) and press OK
  5. novaPDF will ask you where to save the PDF and (if set so) it will open the PDF when it's created. You will have to repeat these steps for each individual sheet in your workbook.
The above method is recommended when you have different printing settings for each page (for instance if you have a Header/Footer set for each page). However, if you have the same printing settings for each sheet in the workbook, you can change the Page Setup options for all sheets at once. Please note that by using this method you will have the same settings for all sheets, including the header/footer. To set the same Page Setup options for all individual Excel sheets:
  1. Open the Excel workbook
  2. Right-click the tab for any of the sheets you have in your workspace (by default they sheet tabs are named Sheet1, Sheet2, ...)
  3. Choose the Select all Sheets option (which will select all the sheets in your workspace, you can tell they're selected if all the sheet tabs have a white background like an active sheet tab would have)
  4. In Microsoft Excel 2007 go to Page Layout and click on the expand button for the Page Setup dialog (for Microsoft Excel 2003 or earlier go to File->Page Setup). Set the Print Quality to the DPI value you want and press OK so that Excel will record the fact that all pages have the same print settings. It's important to press the OK button even if you don't change anything, because this will "tell" Excel that all the sheets have the same page setup options.
  5. Click on the Office button then Print->Print Preview and see if you like the way the pages will show when printed to PDF. If you don't have any changes to the printing options click on the Office button and then on Print, select the Entire Workbook option under Print What and novaPDF from the Printer name section and click OK to create the PDF file
  6. novaPDF will ask you where to save the PDF and (if set so) it will open the PDF when it's created.
Starting with version 6, novaPDF now includes a PDF merging (combining) option, so another way to have multiple individual Excel sheets printed to a single PDF would be to use novaPDF's own merge option. This will let you print the first sheet to a PDF document and after that print all the other sheets in that workbook to the same pdf. You can read more about the PDF merging option here: Merge PDF files with novaPDF

Applies to:
  • novaPDF (all editions)
  • Microsoft Excel 2007
  • Microsoft Excel 2003
  • Microsoft Excel 2002
  • Microsoft Excel 2000
Showing: 1-20 of 22    »»
Comments

04 Aug, 2010   |  Hamish
Thank you so much. Have been trying to fix this problem, periodically, for several years.


06 Jan, 2010   |  Claudiu
Farzad, in your case another solution is to use the merging option that novaPDF has, please see this article for details - http://www.novapdf.com/kb/merge-pdf-files-with-novapdf-146.html


24 Dec, 2009   |  sisi
thankx

now i can print entire excel sheet in 1 file pdf.

when the first time i tried, i click ok after page setup like you said, but entire sheet have same page option and my page totally change when i click print preview.
and i try to change print resolution for each sheet to 600, and succeed.
thx


07 Dec, 2009   |  Farzad
Great set of instructions. Thanks.
My issue is that I need to have a different header for each sheet. And when the print setup is made common to all the sheets in order to produce a single pdf file all the sheets will have the same header. Any solution for that one?

Thanks again.


07 Sep, 2009   |  Peter Rice
Excellent - your guide worked for me too. Thank you.


24 Aug, 2009   |  jeremy
Hi, I find this works only if the total number of pages to be printed to the PDF is 9 or less. The 10th page an onwards get cutoff and not included in the pdf. Has anyone else seen this problem?


21 Aug, 2009   |  Harry Rhoades
This is very helpful. I couldn't figure out why only 2 of 4 sheets printed to the PDF. Turns out the print quality wasn't set on the last two sheets. Set them, but didn't have to do the Page setup or set print area.


14 Aug, 2009   |  Claudiu
@Alan Thebert - Yes you can print multiple single Word documents to a single pdf file with novaPDF using its PDF merge function. See the tutorial here - http://www.novapdf.com/kb/merge-pdf-files-with-novapdf-146.html


28 Jul, 2009   |  Alan Thebert
How to do a similar single PDF document from multiple single MSWord page files? Primopdf will let me append pages 1 - 9, but "conversion fails 18" on page 10. Can NOVAPDF append pages, and if so, how to do it, please?


07 Jul, 2009   |  Stoicescu Catalin
works for me too... doPdf
thank you


02 Jul, 2009   |  scottie
Crackin!! Great job :O)


26 Jun, 2009   |  XVE (Belgium)
Thanks. You really helped me a lot !


17 Jun, 2009   |  MS
Thanks. I was trying to figure out why Excel was sending two jobs, and this was it.


15 Jun, 2009   |  Reggie
You are marvelous! So simple an answer but yet so elusive for those of us not in the know.


23 May, 2009   |  Russell
I use another PDF printer and I still found this advice to be fantastic!! You are a legend.


24 Apr, 2009   |  James
Excellent information. I was so frustrated that I pulled out my hair, but I thank you for saving my life!


06 Feb, 2009   |  Opa
This is awesome, thanks!


05 Feb, 2009   |  Annapoorani.m
Thankyou very much...


22 Jan, 2009   |  Gava
you saved me! MWAH!!


08 Jan, 2009   |  Colin
Thank you.

I was having this problem when printing to pdf and as a standard print job from Excel.

Your solution has fixed this for me and saved a load of time trying to figure it out!


Showing: 1-20 of 22    »»


Add comment
Name:
Email:
* Comment:
(Use BBcode - No HTML)


Others in this Category
document Reduce PDF file size
document Convert XPS to PDF
document Adding PDF bookmarks with novaPDF
document Convert projects created with Microsoft Office Project to PDF files
document Can I convert .lit files to .pdf files using novaPDF?
» More articles
RSS

Legal Notices Terms of Use

Copyright Softland 2010. All rights reserved.