print all worksheets of Excel file to one pdf file

[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?

 

[Dave Peterson]

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]

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.

 

[Maria]

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