View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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