| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Multiple Sheets to PDF Problem
Hello,
I have a workbook of 13 tabs. I am trying to print 9 of them to a single PDF file. I highlight, all 9 sheets by pressing and holding the Ctrl key, then press print. The result is 3 seperate PDF files (PDF1 with sheets 1-4 combined, PDF2 file with sheets 5 & 6 combined, and PDF3 with sheets 7-9 combined). Additionally, it seems to always group the same sheets together. For example, if I select sheets 1, 2, 6, 8, and 9 for printing, sheets 1 & 2 will be one PDF, 6 will be its own PDF, and 8 & 9 will be the third PDF. Why is it doing this? How can I get all 9 sheets to print to a single PDF file? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print Multiple Sheets to PDF Problem
Hi Todd,
Here is a solution by Ken Puls to "Print Multiple Worksheets to a Single PDF File:" http://www.excelguru.ca/node/21#MultiSingle it has been written to use PDFCreator which is free. You should of course read from the beginning of the top of the page. -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "ToddEZ" wrote in message ... Hello, I have a workbook of 13 tabs. I am trying to print 9 of them to a single PDF file. I highlight, all 9 sheets by pressing and holding the Ctrl key, then press print. The result is 3 *separate* PDF files (PDF1 with sheets 1-4 combined, PDF2 file with sheets 5 & 6 combined, and PDF3 with sheets 7-9 combined). Additionally, it seems to always group the same sheets together. For example, if I select sheets 1, 2, 6, 8, and 9 for printing, sheets 1 & 2 will be one PDF, 6 will be its own PDF, and 8 & 9 will be the third PDF. Why is it doing this? How can I get all 9 sheets to print to a single PDF file? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print Multiple Sheets to PDF Problem
That solution is a little intense for my needs, but thanks for the reference.
As a side, I found that if I print from the print preview screen (vs. selecting FilePrint), it will print all pages to one file. Strange... just a Microsoft quirk I guess... Thanks! "David McRitchie" wrote: Hi Todd, Here is a solution by Ken Puls to "Print Multiple Worksheets to a Single PDF File:" http://www.excelguru.ca/node/21#MultiSingle it has been written to use PDFCreator which is free. You should of course read from the beginning of the top of the page. -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "ToddEZ" wrote in message ... Hello, I have a workbook of 13 tabs. I am trying to print 9 of them to a single PDF file. I highlight, all 9 sheets by pressing and holding the Ctrl key, then press print. The result is 3 *separate* PDF files (PDF1 with sheets 1-4 combined, PDF2 file with sheets 5 & 6 combined, and PDF3 with sheets 7-9 combined). Additionally, it seems to always group the same sheets together. For example, if I select sheets 1, 2, 6, 8, and 9 for printing, sheets 1 & 2 will be one PDF, 6 will be its own PDF, and 8 & 9 will be the third PDF. Why is it doing this? How can I get all 9 sheets to print to a single PDF file? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print Multiple Sheets to PDF Problem
I think I like your solution better too, as I would only be
doing such things manually anyway. Anyway had some interesting reading. NASA used Ken's solution or a modification: http://www.managementmag.com/index.c...d/9127/la_id/1 "ToddEZ" wrote in message ... That solution is a little intense for my needs, but thanks for the reference. As a side, I found that if I print from the print preview screen (vs. selecting FilePrint), it will print all pages to one file. Strange... just a Microsoft quirk I guess... Thanks! "David McRitchie" wrote: Hi Todd, Here is a solution by Ken Puls to "Print Multiple Worksheets to a Single PDF File:" http://www.excelguru.ca/node/21#MultiSingle it has been written to use PDFCreator which is free. You should of course read from the beginning of the top of the page. -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "ToddEZ" wrote in message ... Hello, I have a workbook of 13 tabs. I am trying to print 9 of them to a single PDF file. I highlight, all 9 sheets by pressing and holding the Ctrl key, then press print. The result is 3 *separate* PDF files (PDF1 with sheets 1-4 combined, PDF2 file with sheets 5 & 6 combined, and PDF3 with sheets 7-9 combined). Additionally, it seems to always group the same sheets together. For example, if I select sheets 1, 2, 6, 8, and 9 for printing, sheets 1 & 2 will be one PDF, 6 will be its own PDF, and 8 & 9 will be the third PDF. Why is it doing this? How can I get all 9 sheets to print to a single PDF file? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consistent print settings across multiple sheets | Excel Discussion (Misc queries) | |||
| Print 1st Page Multiple Sheets in Same Workbook | Excel Discussion (Misc queries) | |||
| how to print multiple work sheets using vba | Excel Discussion (Misc queries) | |||
| Print multiple excel sheets in color | Setting up and Configuration of Excel | |||
| How do I set print areas for multiple sheets simultaneously? | Excel Discussion (Misc queries) | |||
Linear Mode
