Excel 2007 : Help resizing print area to fill full landscape

When form was updated from Excel 2003 to 2007, 2007 changed the size of the print area so when the file is printed it does not fill the complete printed page and it has the header in wierd places.

How do I reposition the header and page breaks to fill a landscape correctly?

Have you tried clearing the print area and resetting it?

In Excel 2007:

Select Page Layout on the Ribbon Menu
Click on Print Area and clear it

The reselect the print area in the worksheet, then click Print Area in the menu and set it.

If this doesn't help, post your workbook so someone can take a look.