i have a report for jobs that have been onsite for more than 2 days without
an estimate, this report can often be several pages long, while onscreen i
use freeze panes to keep the headers visible all the time when scrolling it
doesnt help me when i have to print the document for my colleagues, when i
print for my colleagues i want it to print this header row on every page of
the spreadsheet without me having to manually paste it in each time, i
beleive theres a way to do this in excel but dont know how, can someone tell
me how you do this please?

--
Stuart