In Excel, once you do a Print Preview, gridlines will be displayed that show where the page breaks will occur. You can also insert manual page breaks to make them occur earlier if you want.

Excel also allows you to change the page orientation.

As for scripting, since I haven't seen your data and don't know exactly what you're trying to achieve, that would be rather difficult.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]