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
Bookmarks