Assuming the information you want as your header is in row 1 go to File>Page
Setup. Go to the Sheet tab and select the button next to "Rows to repeat at
top:" then click on row 1. Push Enter then click OK. If I understand your
question correctly this should give you the results you're looking for.
Regards,
Mike