Excel 2007 printing hell

I have so many times regretted the decision to buy Office 2007 when I bought
my computer. I've just never been able to find or use all the functions I
had in Office XP.

I hope someone out there can help me.

Previously in Office XP, when you have a spreadsheet with several columns
with varying amounts of information in them, it would print the pages out by
extending the column with the most data in it down to the end of the page
and then simply continguously printing all the subsequent information on
subsequent pages, again, the column with the most data in it defining the
end of the page.

Now, with Office 2007, if data in a column extends past the length of the
page, it CUTS off the data that won't fit rather than printing the remainder
of it on the next page. Absolutely infuriating!! I've tried auto height
columns, I've tried defining a print area, I've tried all the settings I can
in the print area. Nothing works, and it still wants to clip off any data
that won't fit in the columns when it prints (though they are visible in the
worksheet)

I have tried every print setting I can think of, and nothing seems to work
to make this beast print out my data contiguously like it did before. I've
tried Googling every variation I can think of, but again, nothing that leads
me to the answer.

Does anybody have any suggestions (short of trying to buy a black market
copy of Office XP...)???


Also, second, does anybody know how to set this thing so that you can scroll
incrementally down a page?? When a column gets long and you try to scroll
down the data, it flips to the top of the next section so that you cannot
scroll to have the end of the longest column and the one underneath it
visible at the same time, which is also very annoying and causes problems in
case you want to drag the handle on the left edge of the longer column to
extend it out--there's no way to GET to the handle because it'll flip you
down to the next page.

Any help will be greatly appreciated.

Jenna W.