Hi forum,

I am using Excel 2007 and have a worksheet of data that I print to PDF every week.

Usually it is 1 page wide and 2 pages long when saved as PDF.

All the sudden I can not get it to fit on 1 x 2 pages anymore.

My settings are "Fit to 1 page(s) wide by 2 tall" but excel ignores this and makes it 1 page wide and 6 long, with bits and peices on each page.

If I try to use scaling instead I get the same. I just can't get it to fit on a page (the last three columns always spill over to a new page).

I have set the size to A4 as always and set a print area. I have mucked about for hours trying every setting I can think of but just can not get the columns to fit on one A4 page.

Any ideas on how I can get this working again?

Thanks very much