Hi Kat,
If you are refering to printed pages, then:
File Page Setup
Then select the 'Sheet' tab and enter your heading row where it says
'Rows to repeat at top'.
I use XL2000. Other versions might be slightly different.
Regards - Dave.