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 of the way Microsoft Excel sends the print job. Excel assumes that all your individual sheets have different page setups, so it sends them as multiple print-jobs.
n order to have all the individual sheets printed within a single PDF file (not multiple PDFs) you need to set the same page setup options for all of them (page setup in Excel modifies the print size of the resulting file, so for example if you set the page layout to landscape in Excel, the printed page will be landscape but your original Excel file will still maintain the same view). To set the same Page Setup options for all individual Excel sheets:
![]() Applies to:
|
Comments
|
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! |
|
27 Oct, 2008
| Lynn Owens
|
|
THANK you so much for this info! Couldn't figure out what happened to my workbook... someone had changed the dpi. |
Showing: 1-20 of 21 »»
Add comment
| Others in this Category | |
| Convert to PDF with novaPDF | |
| Digital PDF signature | |
| Convert Email to PDF | |
| Convert DjVu to PDF | |
| Create active PDF links using novaPDF Professional | |
| » More articles | |


