Not sure what you want. I just took a sample spreadsheet, reduced the paper size so it would have to use more than one sheet, and the following pages always showed the 'header' row and their labels on each page.
I suspect that you need to discover the Show Layout and Print Views rather than maybe maintaining the standard, boring, amazingly dull columns and rows view.
That's always been my most favorite thing to dislike about a spreadsheet. Never displaying any imagination, "Just the facts, ma'am." That's why I enjoy FM so much, the data is secondary, it's how it's displayed that is important.
I actually used to use FM as a page layout app! Probably more for that than making databases!
Most of my time was spent creating 'entry input' screens and evaluating that entry to avoid the proverbial 'garbage in, garbage out' problem. So much data is simply not required to be seen all the time, it just gets in the way. You may already know all that, of course.
The first thing one should do with any of the three iWork apps, in my humble opinion, is to study and play with the "Inspector" pallets in each app. That's where all of the tricks and even standard info is stored and adjusted. Then, play with the included samples and see how different elements are controlled, changed, connected, beautified, etc. If all you've ever done with a spreadsheet is create labels for columns and rows and developed formula for actions, Numbers will simply be a waste of time; stick with Excel/Open Office/etc. Numbers is basically a Pages clone but with data crunching genes spliced in.
So, it's not in the least surprising to me that Numbers is so capable of visual display, the data and the functions list is almost an afterthought!
