I have a spread sheet which fits into a single page and when I go to print, the preview pic indicates everything should be OK, but when I print, only a part, about a half, prints. There's plenty of space, it isn't a case of the spreadsheet being too big.
I've tried hghlighting the table but it still prints only a part of it. I can copy and paste it into a Word document and prints fine.
Any ideas what's going wrong? My older printer never presented this problem.
At a guess, Excel thinks that you're using A4 paper (and bases the preview upon that) but your printer thinks that you've got a smaller paper size loaded (e.g. A5) so it only prints on the relevant area.
When you go to 'Print', click on 'Properties' and look at the paper size setting. (Also check the setting used by Excel in Page Setup).
Maydup, yes I did check my previous post and tried the advice there but still not able to print the whole doc. The printer is set on A4, so I'm stumped, I'll stick to lick and stick until I can sort it out. Thanks for your replies.