I have an excel workbook with several different sheets included. I want to print 20 copies of the entire workbook but when I choose this in the print screen (print entire workbook, 20 copies, collate), it prints out 20 copies of the first 2 sheets, then 20 copies of the next 3 sheets, and finally 20 copies of the last 3 sheets.

Where do I change the options so it will collate the entire workbook? This will save me a huge amount of time.

I have to face this problem to excel printing.I give print in landscape size.landsize gives good results.