Excel "Fit to Pages Wide" Too Small
I'm driving myself mad with this problem!
Basically, the PTB want me to print out about 1,000 marksheets from SIMS (don't get me started on the massive waste of resources that this is, been there already!)
I've written a script that sorts them all out, formats them and prints them, but I'm hitting a massive stumbling black.
For some reason I cannot work out, if I try to fit the sheets on to one page, Excel is squashing them in to the top corner, only using about half the page, rather than actually making it fit as you would expect.
Has anyone ever had this problem and if so how did you fix it?
I have tried doing it manually in case it was my script, but got the same result.
I am setting the print area to only those cells which should be printed - made no difference.