File/Page Setup/ Page:
Rows to repeat at top.
--
David Biddulph

"Stuart" wrote in message
...
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