If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
print all worksheets of Excel file to one pdf file
I have an Excel file with two worksheets. I want to create a pdf file to
send to someone else. I click the following sequence: File Print Entire workbook Printer Adobe pdf Problem is that the new pdf file only contains the first of the two worksheets. How can I get both worksheets to come out in the same pdf file? |
#2
|
|||
|
|||
print all worksheets of Excel file to one pdf file
A complete guess--but it won't take too much time to try it.
Select the first worksheet (click on its tab) ctrl-click on the other tab Then do the file|print (and use Active Sheet(s)) If this doesn't work (and there's a good chance that it won't!), you may want to share what you're using to create the PDF file. Maybe someone who uses that can help. Centerfield wrote: I have an Excel file with two worksheets. I want to create a pdf file to send to someone else. I click the following sequence: File Print Entire workbook Printer Adobe pdf Problem is that the new pdf file only contains the first of the two worksheets. How can I get both worksheets to come out in the same pdf file? -- Dave Peterson |
#3
|
|||
|
|||
print all worksheets of Excel file to one pdf file
Thanks. This worked with one of my files but not the others. What I did,
finally, was to print each worksheet to a pdf file and then use the Combine Files feature of Adobe Acrobat to bring them into a single file. "Dave Peterson" wrote: A complete guess--but it won't take too much time to try it. Select the first worksheet (click on its tab) ctrl-click on the other tab Then do the file|print (and use Active Sheet(s)) If this doesn't work (and there's a good chance that it won't!), you may want to share what you're using to create the PDF file. Maybe someone who uses that can help. Centerfield wrote: I have an Excel file with two worksheets. I want to create a pdf file to send to someone else. I click the following sequence: File Print Entire workbook Printer Adobe pdf Problem is that the new pdf file only contains the first of the two worksheets. How can I get both worksheets to come out in the same pdf file? -- Dave Peterson |
#4
|
|||
|
|||
print all worksheets of Excel file to one pdf file
Creating 2 or more PDFs and then combining them is not the solution. This
problem needs to be corrected. I had the same problem and now I click on the Acrobat TAB within EXCEL and then CREATE PDF, but FIRST you MUST select ALL tabs within the workbook. I'm not sure if this is a standard tab or if the IT section here at work have created this tab. Microsoft needs to correct this problem and save the user valuable production time. I now have one wonderful PDF containing all 15 tabs together with all worksheets within those tabs. Regards...Maria "Centerfield" wrote: I have an Excel file with two worksheets. I want to create a pdf file to send to someone else. I click the following sequence: File Print Entire workbook Printer Adobe pdf Problem is that the new pdf file only contains the first of the two worksheets. How can I get both worksheets to come out in the same pdf file? |
Thread Tools | |
Display Modes | |
|
|