Excel 2007 : Convert Excel spreadsheet to PDF

[qiqinuinaifen128]

These is my situation
I know how to convert Excel to PDF, but the problem is i have more than 25 sheet in a workbook. I know how to convert each sheet to pdf one by one.
Can anyone share with me any other way to do it easier. i feel that it wasted many time by doing the repeatedly step again and again.

[D_Rennie]

hello.

I take it you are using somethink like .pfd distiller, you could try somethink like for each sheet is workbook loop.

cheers.

[royUK]

Which version of Excel are you using?
Which pdf software?

[Andy Pope]

If you want to save all sheets to a single pdf then select the sheets before publishing, or use the Options button on the Publish as PDF dialog.

Edit: My answer assumes OP has xl2007, as this is the 2007 forum and they say they can already produce pdf.