Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to shrink file sizes after eliminating worksheets in file | Excel Discussion (Misc queries) | |||
Create command button to print multiple worksheets in a excel file | Excel Discussion (Misc queries) | |||
How do I print from a file created from sending a print to a file | Excel Discussion (Misc queries) | |||
Need to print path & file on ALL excel worksheets... | Excel Discussion (Misc queries) | |||
How do you print all worksheets in a file without opening the fil. | Excel Worksheet Functions |