I have an Excel 2010 file that contains two worksheets. I need to print about 200 of these files. I need both of the worksheets to print though, not just the first active worksheet.
I know I could manually select print 'entire workbook' in the print settings if I want to print one. But I don't want to have to go into each file and tell it to print the entire workbook when I print all of these.
Is there a way to set this 'print entire workbook' as a default in the Excel program, itself? Or a registry hack?
Thank you very much!