printing in Excel

Hi there

I know how to print mutiple workbooks, by selecting them and then printing them, however, excel prints each workbook on a seperate page, and I want to print mutyiple workbooks without any page breaks.

Also, I want to know how to print say 3 ranges in 3 workbooks, but all on one page with out page breaks. ( well if more than a page, then it simple keeps printing on page 2.

Thanks