print all worksheets of Excel file to one pdf file

  • Thread starter Thread starter Centerfield
  • Start date Start date
C

Centerfield

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?
 
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.
 
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.
 
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
 
Back
Top