Hello,

On a reular basis I need to do this following procedure:

I have about 25 files. Each file has 5 excel documents. I need to print only one of those files, but all tabs it includes (maximum two tabs). And, I need to print each tab so it fills no more than one A4 sheet.

So, what I did till now was to double click seperately each file-document-tab, access the "print preview" and choose "page layout"-fit 1 by one", and then print each page seperately. Which of course works. But, surely there must be a faster way because this takes a lot of time.... can somone help?

Thank you,
Chaim