Excel Worksheeets print in seperate pdfs.

[moifa]

Hi,

I have an excel file with multiple worksheets. When I print to pdf, it creates seperate pdf for each worksheets. They are all set in portrait mode. Is there a way to print all the worksheets in a multiple pages pdf?

I am currently using the merge function to merge them together but it is annoying.


Thanks.
Moifa

[admin]

It is because the sheets are set with different resolution. Each time the resolution changes a new print job is started and will result in a new pdf file.