Page 1 of 1

Excel Worksheeets print in seperate pdfs.

Posted: Sun May 27, 2012 2:57 pm
by 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

Re: Excel Worksheeets print in seperate pdfs.

Posted: Sun Jun 03, 2012 12:56 pm
by 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.