Printing in Excel 2007

Hi

I have a spreadsheet which I am trying to print on 2 pages in Excel 2007 - should be pretty simple right!! If I set the Page Setup options to fix the report to be 2 pages wide and 1 page tall it automatically sets the print to use about a quarter of each page. If I try to manually set the page scaling (it sets it to 14% if I fix it to 2 pages) to any higher number if goes above 2 pages. I cannot understand why Excel is only using around a quarter of the A4page to print each page on. Is it possible to ensure that a print fits 2 pages but also to get it to use as much of the page as possible? Having 2 tables shrunk into a quarter of the page seems ridiculous but I can't work out how to get it to use more of the available page space....

Thanks

Hi

No - I have set the Print Area so that it just includes the bits I want to print.