How to set frozen pane as header in EXCEL?

Question

i have an excel spreadsheet and its couple of pages long i also have a frozen pane which set rite at the top and i want that frozen part to be printed on top of each page that i print (kinda like header in word) :(

i tried using the header function but dont seem to work maybe coz my frozen cells contain formulas? :(

Answer 1

go to File > Page Setup. Click the "Sheet" tab.  There are options there to set a row (and/or column) to print at the top of each page.

--------edit-------->

in excel 2007 (hate the interface)...go to Page Layout ribbon. I think if you click the arrow at the bottom of the Page Setup group you'll find the option there.